import pandas as pd

data = pd.read_csv("path-of-file.csv")

print("shape of employee.csv file: ")

print(csvData.shape)

shape of employee.csv file:
(8, 5)

Code:

import pandas as pd


data= pd.read_csv("path-of-file.csv",usecols=)


print(data)

Output:

  Name Age Salary
0 Ritesh 25.0 15000.0
1 Akash 26.0 16000.0
2 NaN NaN NaN
3 Mahima 27.0 20000.0
4 Lakshay 28.0 18000.0
5 Manu 25.0 25000.0
6 Nidhi 26.0 NaN
7 Geetu 30.0 28000.0

Code:

import pandas as pd


data= pd.read_csv("path-of-file.csv")


print(data.head(5))

Output:

  empid Name Age City Salary
0 100.0 Ritesh 25.0 mumbai 15000.0
1 101.0 Akash 26.0 Goa 16000.0
2 NaN NaN NaN NaN NaN
3 102.0 Mahima 27.0 Hyderabad 20000.0
4 103.0 Lakshay 28.0 Delhi 18000.0

Code:

import pandas as pd


data = pd.read_csv("path-of-file.csv", header=None)


print(data)

Output:

  0     1    2   3    4
0 empid Name Age City Salary
1 100 Ritesh 25 mumbai 15000
2 101 Akash 26 Goa 16000
3 NaN NaN NaN NaN NaN
4 102 Mahima 27 Hyderabad 20000
5 103 Lakshay 28 Delhi 18000
6 104 Manu 25 Mumbai 25000
7 105 Nidhi 26 Delhi NaN
8 106 Geetu 30 Bangaluru 28000

5. WAP to display employee.csv file without index numbers.

Code:

import pandas as pd


data = pd.read_csv("path-of-file.csv")


print(data.to_string(index=False))

Output:

empid Name Age City Salary
100.0 Ritesh 25.0 mumbai 15000.0
101.0 Akash 26.0 Goa 16000.0
NaN NaN NaN NaN NaN
102.0 Mahima 27.0 Hyderabad 20000.0
103.0 Lakshay 28.0 Delhi 18000.0
104.0 Manu 25.0 Mumbai 25000.0
105.0 Nidhi 26.0 Delhi NaN
106.0 Geetu 30.0 Bangaluru 28000.0

6. WAP to display employee.csv file with new column names.

import pandas as pd


data = pd.read_csv("path-of-file.csv", names=)


print(data)

7. WAP to modify the employee name from Mahima to Harsh.

import pandas as pd

data = pd.read_csv("path-of-file.csv")

df = pd.DataFrame(data)

df = df.replace("Mahima", "Harsh")

print(df)

import pandas as pd

data = pd.read_csv("path-of-file.csv")

df = pd.DataFrame(data)

df.to_csv(""path-of-file-2.csv)

print(df)

import pandas as pd

data = pd.read_csv("path-of-file.csv", usecols=)

df = pd.DataFrame(data)

df.to_csv("path-of-file.csv-2", header=)

print(df)

empid,Name,Age,City,Sal
100,Ritesh,25,mumbai,15000
101,Akash,26,Goa,16000
,,,,
102,Mahima,27,Hyderabad,20000
103,Lakshay,28,Delhi,18000
104,Manu,25,Mumbai,25000
105,Nidhi,26,Delhi,
106,Geetu,30,Bangaluru,28000