Add (Insert) a Column Between Two Columns in a Data.Frame

Python: how to add a column to a pandas dataframe between two columns?

You can use insert:

df.insert(4, 'new_col_name', tmp)

Note: The insert method mutates the original DataFrame and does not return a copy.

If you use df = df.insert(4, 'new_col_name', tmp), df will be None.

How to insert a new column in between columns in dataframe

You can follow this example:

import pandas as pd
from datetime import datetime
df=pd.DataFrame()
df['a']=[1]
df['b']=[2]
print(df)
df['Jan-Month']=datetime(2019,1,1)
df['Feb-Month']=datetime(2019,2,1)
print(df)
df=df.reindex(columns=['Jan-Month','a','Feb-Month','b'])
print(df)

Output:

   a  b
0  1  2

   a  b  Jan-Month  Feb-Month
0  1  2 2019-01-01 2019-02-01

   Jan-Month  a  Feb-Month  b
0 2019-01-01  1 2019-02-01  2

Add a new column between other dataframe columns

In 2 steps, you can reorder the columns:

dat$C <- NA
dat <- dat[, c("A", "C", "B")]
         A  C          B
1  0.596068 NA -0.7783724
2 -1.464656 NA -0.8425972

You can also use append

dat <- data.frame(A = rnorm(2), B = rnorm(2))
as.data.frame(append(dat, list(C = NA), after = 1))

           A   C          B
1 -0.7046408  NA  0.2117638
2  0.8402680  NA -2.0109721

Inserting column(s) into a python pandas dataframe in between other columns using the other column's names as the location?

You can find the position of the 'Chair' column and then add them after that.

df.insert(df.columns.get_loc('Chair') + 1, column='grass', value='')

insert multiple columns between two columns in a data frame and an automated way to fill them

library(fastDummies)

df <- data.frame(Cluster = sample(1:10, 100, replace = TRUE))
df <- dummy_cols(df, select_columns = "Cluster")

---

Related Topics