import pandas as pd
#import numpy
import os
import csv
originalFile=os.path.abspath("C:\\Users\\monis\\Desktop\\Document1.csv")
df = pd.read_csv(originalFile)
df = df[df.LEID != '1']
df.to_csv('C:\\Users\\monis\\Desktop\\correctedfile.csv')
print (df)
Output
LEU LEID PPP YYY LEO
0 1 2 3.0 4.0 5.0
2 2 'AA' NaN NaN NaN
#import numpy
import os
import csv
originalFile=os.path.abspath("C:\\Users\\monis\\Desktop\\Document1.csv")
df = pd.read_csv(originalFile)
df = df[df.LEID != '1']
df.to_csv('C:\\Users\\monis\\Desktop\\correctedfile.csv')
print (df)
Output
LEU LEID PPP YYY LEO
0 1 2 3.0 4.0 5.0
2 2 'AA' NaN NaN NaN