Displaying 1 result from an estimated 1 matches for "annual_data3".
2011 Feb 28
1
Data type problem when extract data from SQLite to R by using RSQLite
..., 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 pya_var from annual_...