Pandas Method read_csv()

Question 1

How to create Data Set Object ?

Answer 1

df = pd.read_csv(‘dataSets/titanic.csv’)

Question 2

How to create Data Set Object with no header ?

Answer 2

df = pd.read_csv(‘dataSets/titanic.csv’,header=None)

Question 3

How to create Data Set Object by specifying header row ?

Answer 3

df = pd.read_csv(‘dataSets/titanic.csv’,header=0)

Question 4

How to create Data Set object with custom column labels ?

Answer 4

df = pd.read_csv(‘dataSets/titanic.csv’,prefix=’Col-‘)

Question 5

How to create Data Frame Object with selected columns, also manually assign column labels to them ?

Answer 5

colNames=[‘Col-1’,’Col-2’,’Col-3’,’Col-4’]

df = pd.read_csv(‘dataSets/titanic.csv’,usecols=[1,3,4,5],names=colNames)

Question 6

How to create a Data Frame object , by changing datatype of column ?

Answer 6

df2 = pd.read_csv(‘dataSets/titanic.csv’,dtype={‘Survived’:’boolean’})

Question 7

How to assign column names manually while loading csv File ?

Answer 7

colNames=[‘Col-1’,’Col-2’,’Col-3’,’Col-4’]

df = pd.read_csv(‘dataSets/titanic.csv’,usecols=[1,3,4,5],names=colNames)

Question 8

How to present unique values of colums ?

Answer 8

We have to use unique() method ?

df[‘Sex’].unique()