pandas insert value at position code example

Example 1: pandas insert column in the beginning

insert_index = 0
insert_colname = 'new column'
insert_values = [1, 2, 3, 4, 5] # this can be a numpy array too
df.insert(loc=insert_index, column=insert_colname, value=insert_values)

Example 2: 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)

Example 3: insert row in any position pandas dataframe

line = DataFrame({"onset": 30.0, "length": 1.3}, index=[3])
df2 = concat([df.iloc[:2], line, df.iloc[2:]]).reset_index(drop=True)

Example 4: insert row at given position in pandas dataframe

import pandas as pd
import numpy as np
x=pd.DataFrame([{'BOY':1,'GIRL':44},{'BOY':22,'GIRL':100}])
print(x)
x=x.T #TRANSPOSE IT AND MAKE IT AS COLUMN
x.insert(1,2,[44,56]) #INSERT A NEW COLUMN AT ANY POSITION
x=x.T # NOW TRANSPOSE IT AGAIN TO MAKE IT ROW AGAIN
x=x.reset_index(drop=True) # RESET INDEX 
print(x)

Example 5: 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