I got this following error while running the python program "ValueError: All arrays must be of the same length"
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()