import pandas as pd
# Corrected data with consistent lengths
data = {
'State Name': [
'Andhra Pradesh', 'Arunachal Pradesh', 'Assam', 'Bihar', 'Chhattisgarh',
'Goa', 'Gujarat', 'Haryana', 'Himachal Pradesh', 'Jharkhand',
'Karnataka', 'Kerala', 'Madhya Pradesh', 'Maharashtra', 'Manipur',
'Meghalaya', 'Mizoram', 'Nagaland', 'Odisha', 'Punjab',
'Rajasthan', 'Sikkim', 'Tamil Nadu', 'Telangana', 'Tripura',
'Uttar Pradesh', 'Uttarakhand', 'West Bengal'
],
'Popular Food of the State': [
'Pulihora', 'Thukpa', 'Assamese Thali', 'Litti Chokha', 'Chana Samosa',
'Goan Fish Curry', 'Dhokla', 'Hara Bhara Kabab', 'Chana Madra', 'Litti Chokha',
'Bisi Bele Bath', 'Sadya', 'Poha', 'Puran Poli', 'Eromba',
'Jadoh', 'Bamboo Shoot Curry', 'Dalma', 'Butter Chicken', 'Dal Baati Churma',
'Phagshapa', 'Idli Sambar', 'Hyderabadi Biryani', 'Mizoram Thali',
'Kachori', 'Garlic Chutney', 'Chole Bhature'
],
'Population of the State': [
49577103, 1382611, 34860616, 104099452, 30797877,
2116547, 68775003, 29358700, 6864600, 32966238,
61095297, 3610947, 86870211, 112374333, 11971578,
29111656, 10682609, 72147030, 43558970, 10729899,
23756621, 25575103, 124076437, 11421195, 90800000
],
'Land Area': [
162968, 83743, 78438, 94163, 137441,
3702, 196024, 44212, 55673, 79714,
191791, 38863, 308350, 307713, 21081,
22429, 7096, 130058, 114840, 10486,
58125, 5103, 94203, 25816, 101387
],
'Capital City': [
'Amaravati', 'Itanagar', 'Dispur', 'Patna', 'Raipur',
'Panaji', 'Gandhinagar', 'Chandigarh', 'Shimla', 'Ranchi',
'Bengaluru', 'Thiruvananthapuram', 'Bhopal', 'Mumbai', 'Imphal',
'Shillong', 'Aizawl', 'Kohima', 'Bhubaneswar', 'Chandigarh',
'Jaipur', 'Gangtok', 'Chennai', 'Hyderabad', 'Agartala',
'Lucknow', 'Dehradun', 'Kolkata'
],
'Gender Ratio': [
993, 938, 954, 916, 991,
971, 919, 879, 972, 941,
973, 1084, 931, 925, 970,
978, 971, 944, 989, 965,
940, 963, 908, 980
]
}
# Check if all lists have the same length
lengths = [len(v) for v in data.values()]
if len(set(lengths)) != 1:
raise ValueError("All arrays must be of the same length")
# Create DataFrame
df = pd.DataFrame(data)
# Save to CSV
df.to_csv('indian_states_dataset.csv', index=False)
print("Dataset saved to 'indian_states_dataset.csv'")