How to compare boxplot bw many data frames?

[vanphuht91]

I have many data frame like table below:
what I want is plot box plot of each column & compare line by line.
   
I'm new member, can you help me.
Thanks so much!

[Larz60+]

what have you tried so far?
Please show code, working or not.

[vanphuht91]

what have you tried so far?
Please show code, working or not.

My code already worked, but I want shortened this code, because have many column need to check.
Do we have idea to resolve it?

import matplotlib.pyplot as plt
import pandas as pd

file = 'E:/Document/python/Book1.xlsx'
df = pd.read_excel(file)
data1_tester1 = df[df['Tester']=='Tester 1']['Data1']
data1_tester2 = df[df['Tester']=='Tester 2']['Data1']
data1_tester3 = df[df['Tester']=='Tester 3']['Data1']
data1_tester4 = df[df['Tester']=='Tester 4']['Data1']
data1_tester5 = df[df['Tester']=='Tester 5']['Data1']
data2_tester1 = df[df['Tester']=='Tester 1']['Data2']
data2_tester2 = df[df['Tester']=='Tester 2']['Data2']
data2_tester3 = df[df['Tester']=='Tester 3']['Data2']
data2_tester4 = df[df['Tester']=='Tester 4']['Data2']
data2_tester5 = df[df['Tester']=='Tester 5']['Data2']
ax1 = plt.subplot(2,1,1)
ax1.boxplot([data1_tester1,data1_tester2,data1_tester3,data1_tester4,data1_tester5])
ax1.set_xticklabels('')
ax2 = plt.subplot(2,1,2)
ax2.boxplot([data2_tester1,data2_tester2,data2_tester3,data2_tester4,data2_tester5],labels=['Tester 1','Tester 2','Tester 3','Tester 4','Tester 5'])
plt.show()

[Larz60+]

Please tell me what your goal is (what you expect the output to look like). The code as presented looks rather bazzar.

[vanphuht91]

Please tell me what your goal is (what you expect the output to look like). The code as presented looks rather bazzar.

Actually, my code is working. But what I want is shortern code at assign variables step. Because, we have so many collumn need to check.
If we only assign manual row by row. It will be 10 data * 5 tester = 50 rows need to manual assign at this examples
I can't image how we assign variables for 100 data & 10 tester
Can we use loop or have any idea to resolve it?
This is result of my code:
   

[Larz60+]

You can replace the data load as follows

you can probably also iterate the plot in a similar fashion

import matplotlib.pyplot as plt
import pandas as pd
 
tester = {}

file = 'E:/Document/python/Book1.xlsx'
df = pd.read_excel(file)

for name in df.columns:
    if name.startswith('Data'):
        new_colname = f"{name}_tester{name[4:]}"
        tester[name] = df.filter(items=[name])

# How to use:
print(tester.keys())
print(f"\n{tester['Data1']}")
print(f"\n{tester['Data2']}")

# ax1 = plt.subplot(2,1,1)
# ax1.boxplot([data1_tester1,data1_tester2,data1_tester3,data1_tester4,data1_tester5])
# ax1.set_xticklabels('')
# ax2 = plt.subplot(2,1,2)
# ax2.boxplot([data2_tester1,data2_tester2,data2_tester3,data2_tester4,data2_tester5],labels=['Tester 1','Tester 2','Tester 3','Tester 4','Tester 5'])
# plt.show()

output of printf statements above:

Output:
dict_keys(['Data1', 'Data2', 'Data3', 'Data4', 'Data5', 'Data6', 'Data7', 'Data8', 'Data9', 'Data10'])

    Data1
0    6.91
1    5.79
2    7.12
3    7.61
4    7.70
..    ...
94   7.92
95   6.66
96   7.07
97   5.64
98   7.18

[99 rows x 1 columns]

    Data2
0   20.96
1   18.78
2   21.05
3   21.96
4   20.47
..    ...
94  19.92
95  21.09
96  20.94
97  18.86
98  18.41

[99 rows x 1 columns]