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