True / False For Data Transfer between Files, SQL Database and Data frames Class 12

True / False For Data Transfer between Files, SQL Database and Data frames Class 12 Informatics Practices (IP)

1. CSV files can only store comma separated values.

2. The number of rows in a dataframe are by default equal to number of rows in a CSV file, it created from a CSV file.

3. Pandas can only read from CSV files but can't write CSV files.

4. You need to import CSV package in order to store a dataframe in a CSV file.

5. The read_csv() can handle different separator characters but not to_csv( ).

6. In order to read from a MySQL table into a dataframe, the table must exist.

7. The to_sql() function can append to a MySQL table.

8. The to_sql() function cannot create a MySQL table.

9. The to_sql() function cannot work if the named table already exists.

10. The read_sql() can also read from CSV files.

Answer :-

1. FALSE
2. TRUE
3. FALSE
4. FALSE
5. FALSE
6. TRUE
7. TRUE
8. FALSE
9. FALSE
10. FALSE