Refer database tables in R -
i have database name team has 40 tables . how can connect database , refer particular table without using sqlquerry. use of r data structures.
i not sure mean "how can connect database , refer particular table without using sqlquerry".
i not aware of way "see" db tables r dataframes or arrays or whatever without importing tuples first through sort of query (in sql) - seems practical way use r db data (without going hassle of exporting these .csv files first, , re-read them in r).
there couple ways import data db r, result of query becomes r data structure (including proper type conversion, ideally).
- here short guide on how sql-r
- a similar brief introduction dbi family
Comments
Post a Comment