Scribd
Upload
77 views3 pages

CSV and DataFrame Operations in Python

The document discusses reading and writing CSV and text files using Pandas in Python. It creates CSV files with student data, reads the files into DataFrames, and prints, selects, and writes subsets of the data to new files. CSV files with 10 rows of student roll numbers, names and marks are created. DataFrames are used to read the CSV files, print and select the first few and last few rows, and write the subsets to new CSV and text files.

Uploaded by

Prachi Aggarwal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
77 views3 pages

CSV and DataFrame Operations in Python

The document discusses reading and writing CSV and text files using Pandas in Python. It creates CSV files with student data, reads the files into DataFrames, and prints, selects, and writes subsets of the data to new files. CSV files with 10 rows of student roll numbers, names and marks are created. DataFrames are used to read the CSV files, print and select the first few and last few rows, and write the subsets to new CSV and text files.

Uploaded by

Prachi Aggarwal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

# [Link] a csv file [Link] with ten rows(Roll no , name , marks).

# Read csv file and assign to data frame df.

import pandas as pd
df=pd.read_csv("./files/[Link]")
df

Rollno Name Marks


0 1 Prachi 98
1 2 Paridhi 99
2 3 Aadya 56
3 4 Priya 90
4 5 Sehaj 50
5 6 Dhairya 80
6 7 Sneha 88
7 8 Jhanvi 78
8 9 Pragati 86
9 10 Tanya 70

# Print first 6 observation and save to data frame df1.

df1 = df[:6]

print(df1)

Rollno Name Marks


0 1 Prachi 98
1 2 Paridhi 99
2 3 Aadya 56
3 4 Priya 90
4 5 Sehaj 50
5 6 Dhairya 80

# Write df1 to csv and colon separated file.

df1.to_csv("./files/[Link]")

df1.to_csv("./files/[Link]",sep=":")

df2=pd.read_csv("./files/[Link]")

df2

Unnamed: 0 Rollno Name Marks


0 0 1 Prachi 98
1 1 2 Paridhi 99
2 2 3 Aadya 56
3 3 4 Priya 90
4 4 5 Sehaj 50
5 5 6 Dhairya 80

# Q2. Create a data frame df3 Reading only three rows from [Link]
df3=pd.read_table("./files/[Link]",sep=',',nrows=3)

df3

Rollno Name Marks


0 1 Prachi 98
1 2 Paridhi 99
2 3 Aadya 56

# Create a txt file [Link] with ten rows(Roll no , name , marks).


Read [Link] file and assign to df9.

df9=pd.read_csv("./files/[Link]")

df9

Rollno Name Marks


0 1 Prachi 98
1 2 Paridhi 99
2 3 Aadya 56
3 4 Priya 90
4 5 Sehaj 50
5 6 Dhairya 80
6 7 Sneha 88
7 8 Jhanvi 78
8 9 Pragati 86
9 10 Tanya 70

# Print first 5 observation and save to data frame df10

df10=pd.read_table("./files/[Link]",sep=',',nrows=5)

df10

Rollno Name Marks


0 1 Prachi 98
1 2 Paridhi 99
2 3 Aadya 56
3 4 Priya 90
4 5 Sehaj 50

# Print last 4 observation and save to data frame df11.

df11=pd.read_table("./files/[Link]",sep=',',skiprows=[1,2,3,4,5,6])

df11

Rollno Name Marks


0 7 Sneha 88
1 8 Jhanvi 78
2 9 Pragati 86
3 10 Tanya 70
# Write df10 to a csv file.

df10.to_csv("./files/[Link]",sep='|')

df10

Rollno Name Marks


0 1 Prachi 98
1 2 Paridhi 99
2 3 Aadya 56
3 4 Priya 90
4 5 Sehaj 50

You might also like