Question

you are given a big data set contained in a file big.csv with at least two million records. excel cannot handle it. you decide to use r and rstudio to load the data into r memory. you use the file menu and import dataset. which submenu should you click? from spss from sas from excel from text

Explanation:

CSV (Comma - Separated Values) is a text - based file format. When importing a CSV file into R using the File menu in RStudio, the appropriate sub - menu is "From Text" as it is used for importing text - based data files. Options "From SPSS" and "From SAS" are for importing data from SPSS and SAS specific file formats respectively. "From Excel" is for Excel files, but the problem states Excel cannot handle the data (likely due to size), and the file is in CSV format which is a text - like format (even though it has a.csv extension, it is essentially a text file with comma - separated values).

Answer:

From Text