Display/Print one column from a DataFrame of Series in Pandas

Question

I created the following Series and DataFrame:

import pandas as pd

Series_1 = pd.Series({'Name': 'Adam','Item': 'Sweet','Cost': 1})
Series_2 = pd.Series({'Name': 'Bob','Item': 'Candy','Cost': 2})
Series_3 = pd.Series({'Name': 'Cathy','Item': 'Chocolate','Cost': 3})`
df = pd.DataFrame([Series_1,Series_2,Series_3], index=['Store 1', 'Store 2', 'Store 3'])

I want to display/print out just one column from the DataFrame (with or without the header row):

Either

Adam 
Bob 
Cathy

Or:

Sweet
Candy
Chocolate

I have tried the following code which did not work:

print(df['Item'])
print(df.loc['Store 1'])
print(df.loc['Store 1','Item'])
print(df.loc['Store 1','Name'])
print(df.loc[:,'Item'])
print(df.iloc[0])

Can I do it in one simple line of code?

@JohnGalt Hi, I am starting out to learn pandas and trying to grasp the usage of different functions and methods. — Kane Chew
– Kane Chew, Commented Sep 8, 2017 at 18:59
Are you using IPython and started with 10 Minutes to pandas? — Zero
– Zero, Commented Sep 8, 2017 at 19:00
@JohnGalt I am running a local session of Jupyter Notebook and following a course on Coursera — Kane Chew
– Kane Chew, Commented Sep 8, 2017 at 19:02

BENY · Accepted Answer · 2017-09-08 20:17:08Z

28

By using to_string

print(df.Name.to_string(index=False))


 Adam
  Bob
Cathy

answered Sep 8, 2017 at 20:17

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

piRSquared Over a year ago

to_string makes more sense. Pick this answer please

Tarun Singh · Accepted Answer · 2019-11-17 08:05:31Z

19

For printing the Name column

df['Name']

answered Nov 17, 2019 at 8:05

Tarun Singh

3032 silver badges5 bronze badges

Comments

piRSquared · Accepted Answer · 2017-09-08 19:02:39Z

11

Not sure what you are really after but if you want to print exactly what you have you can do:

Option 1

print(df['Item'].to_csv(index=False))

Sweet
Candy
Chocolate

Option 2

for v in df['Item']:
    print(v)

Sweet
Candy
Chocolate

answered Sep 8, 2017 at 19:02

piRSquared

296k68 gold badges509 silver badges654 bronze badges

Collectives™ on Stack Overflow

Display/Print one column from a DataFrame of Series in Pandas

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related