I’ve run into difficulties sorting lists by column name. The lists come from an excel file, which consists of several columns where each column is named after several variables e.g. “image_0_68_10h_1-13_sunny”. In each column, I have three corresponding rows of data.
I can easily extract one particular row from all columns and assemble this into a list:
However, I wish I could first sort and extract certain columns e.g. all those containing “sunny” or “image_1” in their column name.
I think the problem needs to be solved with python code but since I am not very strong in this it would be nice if someone could give a hint or help me where to start to solve the problem.
This is a .csv file w. my results. But I am working with the file in .xlsx format but I could not upload it in that format. Results_example.csv (8.6 KB)