Run to view results
Run to view results
Run to view results
Run to view results
Run to view results
Run to view results
Run to view results
Run to view results
Run to view results
how many columns and rows did you expect in your final file? Why?
I expected the rows to be about 1000 - 10000 and the columns would be about 80 or less because if you are doing an inner join, the final file will contain only the columns that are present in both DataFrames. If you do an inner join, you can expect the final file to contain the rows where there is a match in both DataFrames. So the row count will be the number of matching rows based on the join condition.
What type of join/merge did you use (inner or outer, left or right)?
I chose an inner join because I need to merge datasets where I need to filter out unmatched records
Run to view results