Append new column to df from list using python

Question

I have list lst = ['vk.com', 'facebook.com', 'avito.ru', 'twitter.com'] and I want to add it to this df:

date    id  request
2016-06-17 09:26:18 [email protected]    GET HTTP/1.1
2016-06-17 09:38:18 [email protected]    GET HTTP/1.1
2016-06-17 10:13:44 [email protected]    GET HTTP/1.1
2016-06-17 10:19:24 [email protected]    GET HTTP/1.1

I try df.append, but it doesn't work.

jezrael · Accepted Answer · 2016-06-23 12:48:59Z

4

If length of list is same as length of df use:

lst = ['vk.com', 'facebook.com', 'avito.ru', 'twitter.com']
df['new'] = lst

print (df)
                  date                    id       request           new
0  2016-06-17 09:26:18  [email protected]  GET HTTP/1.1        vk.com
1  2016-06-17 09:38:18  [email protected]  GET HTTP/1.1  facebook.com
2  2016-06-17 10:13:44  [email protected]  GET HTTP/1.1      avito.ru
3  2016-06-17 10:19:24  [email protected]  GET HTTP/1.1   twitter.com

answered Jun 23, 2016 at 12:48

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Append new column to df from list using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related