Python Forum
Drop a row if it contains a certain value in pandas
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Drop a row if it contains a certain value in pandas
#4
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
Reply


Messages In This Thread
RE: Drop a row if it contains a certain value in pandas - by Daredevil - Nov-08-2018, 07:36 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to drop column in pandas SriMekala 3 3,035 Aug-26-2019, 06:36 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020