Fill In the Blanks For Data Transfer between Files, SQL Database and Data frames Class 12

Fill In the Blanks For Data Transfer between Files, SQL Database and Data frames Class 12 Informatics Practices (IP)

1. Full form of CSV is _____ _____ _____.

2. Default separator of CSV files is _____.

3. To load data of a CSV file in a dataframe _____ function is used.

4. To write data of a dataframe in a CSV file, _____ function is used.

5. To specify a separator other than comma in a CSV file, _____ argument is used.

6. To specify the string to represent NaN values in a CSV file, _____ argument in to_sql() is used.

7. To load data in a dataframe from mysql table, _____ function is used.

8. To write data of a dataframe in a mysql table, _____ function is used.

Answer :-

1. comma separated values
2. , (comma)
3. read_csv
4. to_csv
5. sep
6. na_rep
7. read_sql()
8. to_sql()