How to get all column values from csv using pandas

Question

I have a table in .csv which contains some random messages:

id,msg
2,start
1,bot
1,run
2,san

I want to get only rows which match certain condition. I managed to do that, but I want to get all cell values of column - msg which match condition.

My code:

df = pd.read_csv('msgs.csv')

# if id==2 and msg contains letter 'a'
p = df[(df['id'] == 2) & (df['msg'].str.contains('a'))]
print(p)

for row in p:
    print(p.iloc[0]['msg'])

When I print(p) my result (which is good) is:

           id msg
1          2  start
5          2    san

And I want to have output like this :

start
san

But when I try to do it with iloc I get only first cell value:

start
start

Probably the solution is easy but I don't know how to get it. Thanks in advance.

Orest Xherija · Accepted Answer · 2017-12-06 05:43:19Z

4

You can always do this:

for x in p['msg'].values:
    print(x)

answered Dec 6, 2017 at 5:43

Orest Xherija

4744 silver badges19 bronze badges

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

Comments

janu777 · Accepted Answer · 2017-12-06 05:50:46Z

0

You can always iterate through each row in the csv like this:

for row_number,id,msg in p:
    print(row-number,id,msg)

This will get you the following result:

1 2  start
5 2  san

So if you want just the 'msg' then print this:

for row_number,id,msg in p:
    print(msg)

Hope this helps!

answered Dec 6, 2017 at 5:50

janu777

1,97814 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to get all column values from csv using pandas

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related