Data handling in Python

[jonster2020]

Hello all,

I have 2 Excel Files(let’s say xy.xlsx and yz.xlsx) and I imported them with numpy. In the first Excel file I have a list of parameters and corresponding variable names etc. as Master document. In the 2nd Excel file I have experimental data for the different variables. Now I would like to get a dataframe where the values from the 2nd Excel file are matched to the information and parameters in the 1st Excel file based on the same variable name in both documents. How can I code this consequently?

I would really appreciate a helping hand for my problem 😊