Question: How to merge 2 dataframe in python, I am getting below error import pandas as pd # Step 1 : Reading Data airports _ df

How to merge 2 dataframe in python, I am getting below error
import pandas as pd
# Step 1: Reading Data
airports_df = pd.read_csv('/Users/sureshvelusamy/Documents/Karthika/PY scripts/Airport_Codes.csv')
tickets_df = pd.read_csv('/Users/sureshvelusamy/Documents/Karthika/PY scripts/Tickets.csv')
flights_df = pd.read_csv('/Users/sureshvelusamy/Documents/Karthika/PY scripts/Flights.csv')
# Step 2: Removing Duplicates
cleaned_flights_df=flights_df.drop_duplicates()
cleaned_tickets_df=tickets_df.drop_duplicates()
cleaned_airports_df=airports_df.drop_duplicates()
#Filters
Roundtrip_Tickets = cleaned_tickets_df[tickets_df['ROUNDTRIP']==1]
filtered_flights_df = cleaned_flights_df [cleaned_flights_df ['CANCELLED']==0]
flight_tickets=filtered_flights_df.join(Roundtrip_Tickets, on=('ORIGIN', 'DESTINATION'), how='left')
print (flight_tickets) Error: ValueError Traceback (most recent call last) Cell In[17], line 3315 filtered_flights_df = cleaned_flights_df [cleaned_flights_df ['CANCELLED']==0]17 #check=filtered_flights_df["ORIGIN"].str.len().max()18 #check=filtered_flights_df["ORIGIN"].str.len().min()19 #check=cleaned_tickets_df["ORIGIN"].str.len().max()(...)31 #Merging data 32 #flight_tickets =pd.merge(filtered_flights_df,Roundtrip_Tickets, on=('ORIGIN', 'DESTINATION'), how='left')--->33 flight_tickets=filtered_flights_df.join(Roundtrip_Tickets, on=('ORIGIN', 'DESTINATION'), how='left')34 print (flight_tickets) File /Library/Frameworks/Python.framework/Versions/3.13/lib/python3.13/site-packages/pandas/core/frame.py:10757, in DataFrame.join(self, other, on, how, lsuffix, rsuffix, sort, validate)10747 if how == "cross": 10748 return merge(10749 self, 10750 other, (...)10755 validate=validate, 10756)>10757 return merge(10758 self, 10759 other, 10760 left_on=on,
...
1610)1611 right_on =[None]* n 1612 elif right_on is not None: ValueError: len(left_on) must equal the number of levels in the index of "right"

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!