如何在多个工作表中找到每个索引的最小值?
假设:
worksheet 1
index A B C
0 2 3 4.28
1 3 4 5.23
worksheet 2
index A B C
0 9 6 5.9
1 1 3 4.1
worksheet 3
index A B C
0 9 6 6.0
1 1 3 4.3
...................(Worksheet 4,Worksheet 5)...........
by comparing C column, I want an answer, where dataframe looks like
index min(c)
0 4.28
1 4.1