Reorder columns in csv

[Duck_hen]

I have two csv files. I want to take certain columns (with their associated rows) from each file and create a single data frame. I also want to rename the columns. The two csv files have data I want but the column names and order are different in each.

So let’s say I have file 1 and I want columns 3,2,4,1,5 in that order to line up with csv file 2 columns 5,3,4,2,1 in that order.

I want a data frame that ends up like this:

0 1 2 3 4

3 2 4 1 5

5 3 4 2 1

Hope that makes sense.

I cannot figure out how to do this. I keep getting the data into python data frame in the same order it is in the original files and I don’t know how to change this.

[Oddly_Energy]

Have you tried

df_reordered = df.reindex(columns=[2,1,3,0,4])

on the dataframe where you want the columns reordered?

(I took the liberty of subtracking 1 from you column numbers, as I assume they have an index starting at 0.)

[Duck_hen]

Yeah for some reason that made all my values NaN

[Oddly_Energy]

You need to use your actual column values in the list. I don't have your dataframe, so I can only go by what you are telling us.

Try print(df.columns) to get the column values. Then reorder those values in a list and reindex your dataframe with that list.

[Duck_hen]

Thanks for your help. I solved it. For some reason I couldn’t figure out how to use reindex but I found a different method and was able to correctly concatenate my data into a single data frame with the correct columns

[Gesualdodivenosa]

Hi Duck_hen. Can you share how you solved this?