python pandas print element of dataframe

Question

I have a pandas data frame named country_codes:

>>> country_codes.head(3)

       COUNTRY FIPS ISO2 ISO3

0  Afghanistan   AF   AF  AFG

1      Albania   AL   AL  ALB

2      Algeria   AG   DZ  DZA

given a particular fips code:

>>> fips = 'RS'

I select the country name corresponding to that fips code:

>>> country = country_codes[country_codes['FIPS']==fips]['COUNTRY']

and print it:

>>> print(country)

201    Russia

Name: COUNTRY, dtype: object

I want to use that country name in the title of a matplotlib plot. I want the country name only. I do not want the index number or the line that says Name: COUNTRY, dtype: object. How do I get the name only?

Weston · Accepted Answer · 2017-12-14 16:14:33Z

4

You're getting a series from indexing the dataframe

>>> country = country_codes[country_codes['FIPS']==fips]['COUNTRY']
>>> type(country)
<class 'pandas.core.series.Series'>

For a Series, selection by position:

>>> country.iloc[0]
'Russia'

edited Dec 14, 2017 at 16:14

answered Dec 24, 2013 at 21:38

Weston

2,7712 gold badges30 silver badges34 bronze badges

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

1 Comment

Barry Andersen Over a year ago

in other words, I should say country = country_codes[country_codes['FIPS']==fips]'COUNTRY'].iloc[0] >>> print(country) Russia right?

HYRY · Accepted Answer · 2013-12-25 00:18:52Z

1

I think create a series with FIPS as the key and COUNTRY as the value will make the code simpler:

fips = pd.Series(df["COUNTRY"].values, index=df["FIPS"])

then you can get the country by:

fips["AL"]

answered Dec 25, 2013 at 0:18

HYRY

97.8k28 gold badges197 silver badges192 bronze badges

2 Comments

Andy Hayden Over a year ago

Note: this assumes that country codes are unique (though probably a safe assumption).

Weston Over a year ago

This is the way to do it. It is dramatically faster code than navigating the dataframe. One alternate approach to getting the 'COUNTRY' Series indexed by 'FIPS' would be df.set_index('FIPS')['COUNTRY']

KIRAN KUMAR MATAM · Accepted Answer · 2021-11-28 13:49:09Z

0

if you have pandas data series , and how to access via index is as below

import numpy as np
import pandas as pd 
data=np.array([176.2,158.4,167.6,156.2,161.4])
heights=pd.Series(data,index=['s1','s2','s3','s4','s5'])
print(heights['s2'])

answered Nov 28, 2021 at 13:49

KIRAN KUMAR MATAM

3725 silver badges19 bronze badges

Collectives™ on Stack Overflow

python pandas print element of dataframe

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related