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 dataframe in python, I am getting below error
import pandas as pd
# Step : Reading Data
airportsdf pdreadcsvUserssureshvelusamyDocumentsKarthikaPY scriptsAirportCodes.csv
ticketsdf pdreadcsvUserssureshvelusamyDocumentsKarthikaPY scriptsTicketscsv
flightsdf pdreadcsvUserssureshvelusamyDocumentsKarthikaPY scriptsFlightscsv
# Step : Removing Duplicates
cleanedflightsdfflightsdfdropduplicates
cleanedticketsdfticketsdfdropduplicates
cleanedairportsdfairportsdfdropduplicates
#Filters
RoundtripTickets cleanedticketsdfticketsdfROUNDTRIP
filteredflightsdf cleanedflightsdf cleanedflightsdf CANCELLED
flightticketsfilteredflightsdfjoinRoundtripTickets, onORIGIN 'DESTINATION' how'left'
print flighttickets Error: ValueError Traceback most recent call last Cell In line filteredflightsdf cleanedflightsdf cleanedflightsdf CANCELLED #checkfilteredflightsdfORIGINstrlenmax #checkfilteredflightsdfORIGINstrlenmin #checkcleanedticketsdfORIGINstrlenmax #Merging data #flighttickets pdmergefilteredflightsdfRoundtripTickets, onORIGIN 'DESTINATION' how'left' flightticketsfilteredflightsdfjoinRoundtripTickets, onORIGIN 'DESTINATION' how'left' print flighttickets File LibraryFrameworksPythonframeworkVersionslibpythonsitepackagespandascoreframepy: in DataFrame.joinself other, on how, lsuffix, rsuffix, sort, validate if how "cross": return merge self, other, validatevalidate, return merge self, other, leftonon
righton None n elif righton is not None: ValueError: lenlefton 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
