Which package is used to do data import in R and Python and How do you import SAS data?

0 votes

Which package is used to do data import in R and Python respectively and How do you import SAS data?

Aug 24, 2018 in Data Analytics by Anmol
• 1,610 points
32 views

1 answer to this question.

0 votes

We can do data import using multiple methods:

  • In R we use RODBC for RDBMS data, and data.table for fast import.
  • We use jsonlite for JSON data, foreign package for other languages like SPSS
  • We use data and sas7bdat package for SAS data.
  • In Python we use Pandas package and the commands read_csv , read_sql for reading data. Also, we can use SQLAlchemy in Python for connecting to databases.
answered Aug 24, 2018 by Anmol
• 3,620 points

Related Questions In Data Analytics

0 votes
1 answer

How to find out the package version which is loaded in R?

You can use sessionInfo() to accomplish that. > ...READ MORE

answered Apr 18, 2018 in Data Analytics by zombie
• 3,690 points
27 views
0 votes
1 answer
0 votes
1 answer

How to filter a data frame with dplyr and tidy evaluation in R?

Requires the use of map_df to run each model, ...READ MORE

answered May 16, 2018 in Data Analytics by DataKing99
• 8,130 points
93 views
0 votes
1 answer

How to forecast season and trend of data using STL and ARIMA in R?

You can use the forecast.stl function for the ...READ MORE

answered May 18, 2018 in Data Analytics by DataKing99
• 8,130 points
508 views
0 votes
1 answer

Python equivalent to replace function in R

There is actually a replace function in ...READ MORE

answered May 30, 2018 in Data Analytics by Bharani
• 4,550 points
70 views
0 votes
4 answers

Python vs. R for data science

I would say both Python and R ...READ MORE

answered Aug 1 in Data Analytics by briny
106 views
0 votes
1 answer

How to know the type of an object?

To find the type of an object ...READ MORE

answered Sep 19, 2018 in Data Analytics by Anmol
• 3,620 points
33 views
0 votes
1 answer

Define a SQL query? What is the difference between SELECT and UPDATE Query? How do you use SQL in SAS?

Structured query language (SQL) is a programming ...READ MORE

answered Aug 24, 2018 in Data Analytics by Anmol
• 3,620 points
101 views
0 votes
3 answers

Which is a better initiative to learn data science: Python or R?

Well it truly depends on your requirement, If ...READ MORE

answered Aug 8, 2018 in Data Analytics by Anmol
• 3,620 points
53 views