Chapter 4: Importing/Exporting Data Between CSV Files/MySQL and Pandas

Type A : Short Answer Questions / Conceptual Questions

1. What are the advantages of CSV file Format ?

2. What all libraries do you require in order to bring data from a CSV file into a dataframe ?

3. You want to read data from a CSV file in a dataframe but you want to provide your own column names to dataframe. What additional argument would you specify in read_csv() ?

4. By default, read_csv() uses the values of first row as column headers in dataframes. Which argument will you give to ensure that the top/first row’s data is used as data and not as column headers ?

5. Which argument would you give to read.csv() if you only want to read top 10 rows of data ?

6. Write command to store data of dataframe mdf into a CSV file Mydata.csv, with separator characeter as ‘@’.

7. Why do you need connection to an SQL database in order to get data from a table ?

8. What is ‘pymysql’ library of Python ?

9. What all libraries do you require in order to interact with MySQL database (and dataframe) from within python.

10. What additional argument do you need to specify in to_sql() so that old data of MySQL table is retained ?

11. If query is string storing an SQL statement. Write statements so that the data is fetched based on query from SQL database Mydata.

error: Content is protected !!