I am trying to get a list of file names to sort with a specific column in Excel which has all the file names in it (though in a different order than file explorer has sorted them). The files are a bunch of images that I need to be sorted so that the data in the Excel matches the picture that is displayed. However, Python seems to only sort the first 10 files correctly then begins to, seemingly randomly, rearrange the last 20 or so file names.

So I am trying to rename the unemply_states.columns to the names in the dictionary (id_to_state), but I keep getting the error shown. I don’t know if this is a factor but the two have different data types.

So I am trying to rename the unemply_states.columns to the names in the dictionary (id_to_state), but I keep getting the error shown. I don’t know if this is a factor but the two have different data types.

So I am trying to rename the unemply_states.columns to the names in the dictionary (id_to_state), but I keep getting the error shown. I don’t know if this is a factor but the two have different data types.

So I am trying to rename the unemply_states.columns to the names in the dictionary (id_to_state), but I keep getting the error shown. I don’t know if this is a factor but the two have different data types.

My Input

I have a dataframe where I want to sort it based on 3 columns, where one column in particular has a specific mapping I want to use. For example, for this dataframe: