Answers for "pandas insert column at specific index"

3

how to add the column to the beginning of dataframe

# Third position would be at index 2, because of zero-indexing.
df.insert(2, 'new-col', data)
Posted by: Guest on August-18-2020
-1

add column using a list at poisition zero pandas

df = pd.DataFrame({'B': [1, 2, 3], 'C': [4, 5, 6]})

df
Out: 
   B  C
0  1  4
1  2  5
2  3  6

idx = 0
new_col = [7, 8, 9]  # can be a list, a Series, an array or a scalar   
df.insert(loc=idx, column='A', value=new_col)

df
Out: 
   A  B  C
0  7  1  4
1  8  2  5
2  9  3  6
Posted by: Guest on June-30-2020

Code answers related to "pandas insert column at specific index"

Python Answers by Framework

Browse Popular Code Answers by Language