Displaying 1 result from an estimated 1 matches for "pya_var".
2011 Feb 28
1
Data type problem when extract data from SQLite to R by using RSQLite
...m SQLite to R, the data types (or modes) of the
extracted data seems to be determined by the value of the first row.
Please see the following example.
When I put the missing values first, the column extracted is of the
mode character.
> str(dbGetQuery(sql.industry,
+ "select pya_var from annual_data3
+ order by pya_var"))
'data.frame': 155465 obs. of 1 variable:
$ pya_var: chr NA NA NA NA ...
When I put the non-missing values first, the column extracted is of
the mode numeric.
> str(dbGetQuery(sql.industry,
+ "select py...