Read CSV file in python

ReadCSV.py

# Open the CSV file using csv lib
import csv
file = open('Salary_Data.csv')
csvreader = csv.reader(file)
header = []
header = next(csvreader)
header ## print header
rows = []
for row in csvreader:
rows.append(row)
rows ## Print rows

# Open the CSV file using readlines()
with open('file.csv', 'r') as file:
    ## Read all lines from the file
    lines = file.readlines()
    
header = lines[:1]
rows = lines[1:]

## Iterate over each line
for line in lines:
    ## Split the line into fields using comma as the delimiter
    fields = line.strip().split(',')
    ## Print each field
    print(fields)
    
# Open the CSV file using pandas
import pandas as pd
data= pd.read_csv("Salary_Data.csv")
data  ## Print data
data.columns ## Extract the field names
data.Salary ## Extract the rows. Assume it has a Salary field.