Pandas- Selecting the columns with specific value

Question

I have a huge csv file and i want to filter out the dataframes with a specific value.

dataf = pd.read_csv('table.txt', sep=',')
dataf[(dataf.Subject_code == '100')]
#print (dataf[(dataf.Subject_code =='100')])

It returns an empty data frame. I get only the headers of the file. I need all the dataframes whose subject code is equal to 100.

Student Subject_code Score 1 100 A 10 500 B 12 100 A 15 100 C

Is there some sample data we can look at? Please look at stackoverflow.com/questions/20109391/… — Roy2012
– Roy2012, Commented Jun 18, 2020 at 17:18
are you sure it's a string column ? try dataf[(dataf.Subject_code == 100)] — Umar.H
– Umar.H, Commented Jun 18, 2020 at 17:19

Igor Rivin · Accepted Answer · 2020-06-18 17:19:45Z

1

Pandas most likely converts strings representing numbers to numbers (you can find out by doing dataf.info() and see if the column is numeric or Object. If it does, you should do equality check against 100 not "100".

answered Jun 18, 2020 at 17:19

Igor Rivin

4,8742 gold badges30 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user13770492 Over a year ago

oh. okay. makes sense

Balaji Ambresh · Accepted Answer · 2020-06-18 17:20:29Z

0

Use this:

print(dataf[dataf.Subject_code == 100])

answered Jun 18, 2020 at 17:20

Balaji Ambresh

5,0022 gold badges7 silver badges17 bronze badges

Collectives™ on Stack Overflow

Pandas- Selecting the columns with specific value

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related