How to read the column using Pandas

Question

I am trying to put a condition to print the revenue which is greater or equal to certain number using Pandas in Python.

I am using the code line" df[df.Total Revenue>=6678690.38]"

I am getting the error "SyntaxError: invalid syntax." beacuse its not taking my column name(Total Revenue) with space. So how to read column if the column header is with space?

Note = df is where I am reading my file

In short, don't use the `df.xxx` notation but always `df['xxx']`, this will always work. — mozway, Apr 20 '22 at 05:02
Wow , this worked. I used the header name with quotes , it worked. Thanks a lot — john, Apr 20 '22 at 10:29

Ularbek Sulaimanov · Answer 1 · 2022-04-20T11:35:53.277

0

this should work

df[df['Total Revenue']>=6678690.38]

edited Apr 20 '22 at 11:35

answered Apr 20 '22 at 04:58

Ularbek Sulaimanov

1
2

Hi , Tried your suggestion but still got the same error "SyntaxError: invalid syntax. Perhaps you forgot a comma?" – john Apr 20 '22 at 10:26

How to read the column using Pandas

1 Answers1