Python

ValueError:All arrays must be of the same length - Python

ValueError:All arrays must be of the same length - Python, someone asked me to explain?

I got this following error while running the python program "ValueError: All arrays must be of the same length"ValueError Python

CODE:

import pandas as pd

Carnivorous_animals = [
        "Lions",
        "Wolves",
        "Eagles",
        "Leopards",
        "Hyenas",
        "Sharks",
        "Tigers",
        "Cheetahs"]
Herbivores_animals = [
        "Horse",
        "Cow",
        "Horse",
        "Sheep",
        "Goat",
        "Deer",
        "Giraffe"]
Omnivores_animals = [ "Bear",
        "Humans",
        "Fox",
        "Crow",
        "Rat",
        "Raccoon",
        "Ravens"]

data = {'Carnivorous Animals': Carnivorous_animals, 'Herbivores Animals ': Herbivores_animals,'Omnivores Animals': Omnivores_animals}

df = pd.DataFrame(data)

excel_file_path = "animals.xlsx"

df.to_excel(excel_file_path, index=False)

print(f"Excel file '{excel_file_path}' created successfully.")

UPDATED CODE:

df = pd.DataFrame.from_dict(data,orient='index').transpose()

Post your comments / questions