csv and DataFrame

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