I apply some functions and generate a new column values to a existing column of Pandas dataframe. However df['col1'] = new_list
does not work to assign new list to the column. Is it the wrong way and what is the accurate way to apply such operation ?
I think this question is looking for something like this.
new_list = [1,2,3]
col1
0 [1,2,3]
1 [1,2,3]
2 [1,2,3]
And I think I found the answer here:
how to assign an entire list to each row of a pandas dataframe
It should work if length of the list is equal to the number of rows in the DataFrame
>>> df = pd.DataFrame({'A':[1,2,3], 'B':[4,5,6]})
>>> df['C'] = [10,20,30]
>>> df
A B C
0 1 4 10
1 2 5 20
2 3 6 30
If your list is shorter or longer than DataFrame, then you'll receive an error Length of values does not match length of index
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With