search

stats4sd / Installation-Guides

A set of installation and basic use guides for software and tools used / recommended by the Research Methods Support / Stats4SD team
GNU General Public License v3.0
0 stars 0 forks source link

MySQL import changes column types for various fields in farmer trials example #64

Closed chrismclarke closed 5 years ago

chrismclarke commented 5 years ago

Noticed that lots of errors are flagged when importing cleaned data, due to expected data types not matching. It appear that the mysql import from excel which defines the variable types makes a few mistakes, notably changing some of the yes/no columns (e.g. farmer own practice) to int.

This doesn't have a huge impact for the example data, but probably worth investigating/solving/advising more in the future.

chrismclarke commented 5 years ago

explicit advice now given, closing