Python Pandas ValueError Arrays Must be All Same Length

Python Pandas ValueError Arrays Must be All Same Length

you can do this to avoid that error

a = {Links : lines ,Titles : titles , Singers: finalsingers , Albums:finalalbums , Years : years}
df = pd.DataFrame.from_dict(a, orient=index)
df = df.transpose()

Its telling you that the arrays (lines, titles, finalsingers, etc…) are not of the same length. You can test this by

print(len(lines), len(titles), len(finalsingers)) # Print all of them out here

This will show you which data is malformed and then youll need to do some investigating into what the right way to correct this is.

Python Pandas ValueError Arrays Must be All Same Length

You can pad the shortest lists with empty elements:

def pad_dict_list(dict_list, padel):
    lmax = 0
    for lname in dict_list.keys():
        lmax = max(lmax, len(dict_list[lname]))
    for lname in dict_list.keys():
        ll = len(dict_list[lname])
        if  ll < lmax:
            dict_list[lname] += [padel] * (lmax - ll)
    return dict_list