concentration_list = saline005 saline010 saline020 saline030 saline040 saline050df_saline_median = pdDataFramecolumns=1kHz_mag2kHz_mag3kHz_mag7kHz_mag11kHz_mag17kHz_mag

for i in concentration_list: saline_group = df[df['name'] == i] saline_median = saline_group[['1kHz_mag','2kHz_mag','3kHz_mag','7kHz_mag','11kHz_mag','17kHz_mag', '23kHz_mag','31kHz_mag','43kHz_mag','61kHz_mag','89kHz_mag','127kHz_mag', '179kHz_mag','251kHz_mag','349kHz_mag']].median() df_saline_median.loc[i] = saline_median print(df_saline_median)