Class 11 IP Chapter 12 Back Exercise Part A Solutions Sumita Arora New Syllabus / Listing11IPSA, Uncategorized / By Neha 7 . Why do you need connection to an SQL database in order to get data from a table ? ...click here for answer 11. If query is a string storing an SQL statement. Write statements so that the data is fetched based on query from SQL database Mydata.db. ...click here for answer 8. What is sqlite3 library of Python ? ...click here for answer 1. What are advantages of CSV file formats ? ...click here for answer 2. What all libraries do you require in order to bring data from a CSV file into a dataframe ? ...click here for answer 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( ) ? ...click here for answer 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 ? 'header' argument ...click here for answer 6. Write command to store data of dataframe mdf into a CSV file Mydata.csv, with separator character as ‘@’. ...click here for answer 5. Which argument would you give to read_csv() if you only want to read top 10 rows of data ? ...click here for answer 9. What all libraries do you require in order to interact with sqlite3 databases (and dataframe) from within Python ? ...click here for answer 10. What additional argument do you need to specify in to_sql() so that old data of SQL table is retained ? ...click here for answer
