Worksheetscsv and DataFrame
Total questions: 10
Worksheet time: 6mins
The acronym csv is short for
Comma Special Values
Comma Separated Values
Case Separated Values
Comma Separate Values
A common format for data interchange
xlsx
csv
docx
table
Method used to bring data from a csv file into a DataFrame
readcsv()
read_table()
read_csv()
read-csv()
Argument used to provide own column headings instead of column headings in csv file
names
header
skiprows
index_col
Select the correct way to give the path of the file in read_csv()
C:/data/myfile.csv
C:\\data\\myfile.csv
C:\data\myfile.csv
C:data/myfile.csv
If the argument header=None is given, what will be the headings
1,2,3 etc
A,B,C etc
0,1,2 etc
I,II,iii
Argument used to skip rows while fetching data from csv file
skiprow
skip_row
SkipRows
skiprows
Default separator of csv
Tab
Space
Comma
Pipe
pd.read_csv(‘data.csv’,skiprows=[1,2,3,6]
What this statement trying to do
Code reads csv file namely data.csv and it will read records 1,2,3,6
Code reads csv file namely data.csv and it will skip 1,2,3,6
Code reads csv file namely data.csv and it will provide headings as 1,2,3,6
Command to be given before doing anything with Pandas
(a)
