How to create a pandas dataframe with a column as array

Question

I want to create a dataframe with one of the column as a list or array But an attempt to do so gives an error 'Must have equal len keys and value when setting with an iterable' Please support

  eg  data.loc[0,'emails']={'[email protected]','[email protected]'} =>error 
      data.loc[0,'emails']='[email protected]' =>No error

Data=>

> Name  | emails
  ___________________________  
> Judas |['[email protected]','[email protected]']
> Priest|['[email protected]','[email protected]','[email protected]']

This scenario could be one like trying to get only list of emails as a column from one of the columns which contains very long texts.

Array-likes in DataFrame columns is often a bad idea, why do you want to do it? — Denziloe
– Denziloe, Commented Sep 10, 2018 at 15:09
I am trying to get list of words of interest from one of the columns which contains long text — Thunder
– Thunder, Commented Sep 10, 2018 at 15:13
Wouldn't the following structure be better? (Rows) Judas, [email protected] | Judas, [email protected] | Priest, [email protected] | ... — Denziloe
– Denziloe, Commented Sep 10, 2018 at 15:16

BENY · Accepted Answer · 2018-09-10 15:14:26Z

3

After you assign a list like or array like value to the columns, the column should be considered as type object

df=pd.DataFrame({'Name':['Juda','Pri']})
df['Email']=''
df.Email=df.Email.astype(object)
df.loc[0,'Email']={'[email protected]','[email protected]'}
df
Out[511]: 
   Name               Email
0  Juda  {[email protected], [email protected]}
1   Pri

answered Sep 10, 2018 at 15:14

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Comments

Jblasco · Accepted Answer · 2018-09-10 15:15:33Z

0

The question could be more clear, to be honest. Does this result in what you expect?

a = ["Judas" , ['[email protected]','[email protected]']]
b = ['Priest', ['[email protected]','[email protected]','[email protected]']]
df = pandas.DataFrame([a,b])
print(df)

gives:

            0                            1
0   Judas           [[email protected], [email protected]]
1  Priest  [[email protected], [email protected], [email protected]]

answered Sep 10, 2018 at 15:15

Jblasco

3,98724 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to create a pandas dataframe with a column as array

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