Font size
WorksheetsPandas - CSV file
Total questions: 10
Worksheet time: 3mins
Full form of CSV file is ...................
Comma Separated Vault
Comma Separated Value
Common Separated Value
Common System Value
Which function from the options given below can read the dataset from a large text file?
read_json
read_pickle
read_hdf
read_csv
Which is the correct Pandas syntax to read in a csv file and assign it to a DataFrame df?
df = read_csv('file.csv')
df = read('file.csv', type = 'csv')
df = pd.read_csv('file.csv')
df = with open('file.csv') as pd.DataFrame
Which of the following object you get after reading CSV file?
DataFrame
Character Vector
Panel
All of the mentioned
Which functions used to transfer data from dataframe to CSV files?
to_data()
to_csv()
df_csv()
from_dataframe()
Which among these are correct , regarding csv files?
A common format for data interchange
Standard way to represent binary data.
It can be opened in spreadsheet packages like MS-Excel, Calc etc
There is no distinction between text and numeric values.
How the mode can be specified, if we want to add the remaining records into already existing csv file?
mode="w"
mode="a"
mode="append"
mode="write"
Which library should be imported, if we want to use the function isfile() ?
pandas
os.path
numpy
random
Which among these is having correct syntax for writing into a csv file?
pd.to_csv(“emp.csv”)
df.tocsv(“emp.csv”)
df.to_csv(“emp.csv”)
(a) argument of read_csv() is used to specify the number of rows to be read from the file.
