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

I was facing the similar error with the message

Shape of passed values is (68, 1783), indices imply (68, 68) in dataframe

And As per my guess, I fed the transpose of ndarray of data and that solved the problem

Changed from

Features_Dataframe = pd.DataFrame(data=Features, columns=Feature_Labels)  # here Features ndarray is 68*1783

To

Features_Dataframe = pd.DataFrame(data=Features.transpose(), columns=Feature_Labels)  # Now Features array became 1783*68 i.e., 1783 rows and 68 columns