How can I test a conditional in a specific column of a csv file in Python

Question

I've figured out how to iterate through a specific column within a csv file with n columns. But now I want to create a conditional and I'm not sure how.

The column in question is a column of days of the week (Monday, Tuesday, etc.). I want to write code so that my iteration counts all the Mondays, all the Tuesdays, so and so forth. This is what I wrote up and I get a syntax error.

mon = 0
# print (df)

days_week = df.iloc[4:,2]
# print(days_week)
for i in days_week:
    if i == "MONDAY"
    mon+=1

The data type for this particular column right now 'object'. So I figure I need to change it to strings?

The syntax for if is very like that of for loops -- you'll need a colon : at the end of the if statement, and to indent the next line. But JALO's answer solves everything nicely. — Dragon
– Dragon, Commented Jun 28, 2020 at 18:00

JALO - JusAnotherLivngOrganism · Accepted Answer · 2020-06-28 17:25:03Z

1

Check pandas value_counts function for series data:

value_counts

e.g. say df['days'] contains your data, then:

df['days'].value_counts() will give you counts for each of the days.

answered Jun 28, 2020 at 17:25

JALO - JusAnotherLivngOrganism

1,2881 gold badge15 silver badges30 bronze badges

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

2 Comments

ixixxsx Over a year ago

Unbelievable, thank you so much! This is so much more efficient than what I was thinking of doing :)

JALO - JusAnotherLivngOrganism Over a year ago

You are most welcome! There are many features in pandas which you will be pleasantly surprised to experience as you go forward. If you need any help, the community is anyways there :)

Collectives™ on Stack Overflow

How can I test a conditional in a specific column of a csv file in Python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related