Multiple definition of … linker error

Don’t define variables in headers. Put declarations in header and definitions in one of the .c files. In config.h In some .c file: If you put a definition of a global variable in a header file, then this definition will go to every .c file that includes this header, and you will get multiple definition … Read more

Unable to install gem – Failed to build gem native extension – cannot load such file — mkmf (LoadError)

There are similar questions: `require’: no such file to load — mkmf (LoadError) Failed to build gem native extension (mkmf (LoadError)) – Ubuntu 12.04 Usually, the solution is: sudo apt-get install ruby-dev Or, if that doesn’t work, depending on your ruby version, run something like: sudo apt-get install ruby1.9.1-dev Should fix your problem. Still not … Read more

Print array to a file

Either var_export or set print_r to return the output instead of printing it. Example from PHP manual You can then save $results with file_put_contents. Or return it directly when writing to file:

Aggregate multiple columns at once

We can use the formula method of aggregate. The variables on the ‘rhs’ of ~ are the grouping variables while the . represents all other variables in the ‘df1’ (from the example, we assume that we need the mean for all the columns except the grouping), specify the dataset and the function (mean). Or we can use summarise_each from dplyr after grouping (group_by) Or using summarise with across (dplyr devel version … Read more

SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

I have faced the same problem a week ago. The problem is with the time zone setting. Specify in other formats like mm/dd/yyyy (usually works). Specifying the date as 30/12/2013 resulted in the error for me. However, specifying it as mm/dd/yyyy format worked. If you need to convert your input the you can try looking into the CONVERT method. … Read more