Getting values from pandas dataframe column

Question

I have ended up with a pandas dataframe which looks like this:

               adm1    per_area_adm1
0          campeche  [2.57978273338]
1           chiapas  [10.9970300459]

Is there a way to get the values from per_area_adm1 column? I can do df['per_area_adm1'].values but that provides an array of lists

sorry, I meant I used .values but that does not work. I will update question — user308827
– user308827, Commented Aug 7, 2017 at 2:10
expected output should be an array of values and not array of lists — user308827
– user308827, Commented Aug 7, 2017 at 2:11

akuiper · Accepted Answer · 2017-08-07 02:12:06Z

3

If each list contains only one element, you can use .str[0]:

df.per_area_adm1.str[0]

#0     2.579783
#1    10.997030
#Name: per_area_adm1, dtype: float64

answered Aug 7, 2017 at 2:12

akuiper

216k33 gold badges362 silver badges379 bronze badges

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

Comments

cs95 · Accepted Answer · 2017-08-07 02:26:06Z

1

Alternatively, df.apply(operator.itemgetter):

In [1026]: import operator

In [1027]: df.per_area_adm1.apply(operator.itemgetter(0)).values
Out[1027]: array([  2.57978273,  10.99703005])

answered Aug 7, 2017 at 2:26

cs95

406k106 gold badges744 silver badges797 bronze badges

Naren Murali · Accepted Answer · 2017-08-07 02:33:35Z

0

you can use this function to reduce the list of lists to just a list

flat_list = [item for sublist in df['per_area_adm1'].values for item in sublist]
print(flat_list)

answered Aug 7, 2017 at 2:33

Naren Murali

66.1k6 gold badges51 silver badges96 bronze badges