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()
Post your comments / questions
Recent Article
- Check hostname requires server hostname - SOLVED
- How to restrict access to the page Access only for logged user in Django
- Migration admin.0001_initial is applied before its dependency admin.0001_initial on database default
- Add or change a related_name argument to the definition for 'auth.User.groups' or 'DriverUser.groups'. -Django ERROR
- Addition of two numbers in django python
- The request was aborted: Could not create SSL/TLS secure channel -Error in Asp.net
- FieldError: Cannot resolve keyword 'id' into field in Django project
- How to hide the ID field from the Django admin?
Related Article