ValueError: Shape of passed values is (1, 6), indices imply (6, 6)

Simply change

col = pd.DataFrame(data, columns=['runs','balls', 'wickets', 'ground_average', 'pp_balls_left', 'total_overs'])

for

col = pd.DataFrame([data], columns=['runs','balls', 'wickets', 'ground_average', 'pp_balls_left', 'total_overs'])

You want [data] for pandas to understand they’re rows.

---

Simple illustration:

a = [1, 2, 3]
>>> pd.DataFrame(a)
   0
0  1
1  2
2  3

>>> pd.DataFrame([a])
   0  1  2
0  1  2  3