How I can read dataframe in R Markdown using SQL?

Question

I can read data from database using this code:

{sql connection=con} SELECT year, sex, age from INFROMATION

but how I can take that to data.frame?

conrad-mac · Accepted Answer · 2017-05-23 19:00:29Z

2

From here:

If you want to assign the results of the SQL query to an R data frame, you can do this using the output.var option.

For example:

{sql, connection=con, output.var="info_query"}
SELECT year, sex, age from INFROMATION

answered Feb 14, 2017 at 7:50

conrad-mac

89310 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daksh Agarwal · Accepted Answer · 2017-02-14 07:47:32Z

0

Did you try to put that directly in data = data.frame({sql connection=con} SELECT year, sex, age from INFROMATION) ?

answered Feb 14, 2017 at 7:47

Daksh Agarwal

1672 silver badges12 bronze badges