Python Pandas Small Script - Comparing 2 Dataframes
Budget: $10 – $30 USD
I have 2 CSV files, attached. These are subsets of very large files with 1000s of records. The data has about500 total records, the addresses has about 10,000 records.
What I need done via pandas is to compare the 2, and if the address from data has a match in the addresses file, then the School value (Mayrose, for example) needs to be populated into the Elementary column of 'data' file.
The output for row 2 below would include Wildberry since there was a matching address (400 Moore).
Status,SchoolCode,BuildingGrade,Address,Elementary
G,FSHS,12,561 Diamond Loop,
G,FSHS,12,400 Moore ,Wildberry
This needs to be done as soon as possible, preference will be given based on price and how long it takes to finish. Please indicate when it will be completed to be considered.
What I need done via pandas is to compare the 2, and if the address from data has a match in the addresses file, then the School value (Mayrose, for example) needs to be populated into the Elementary column of 'data' file.
The output for row 2 below would include Wildberry since there was a matching address (400 Moore).
Status,SchoolCode,BuildingGrade,Address,Elementary
G,FSHS,12,561 Diamond Loop,
G,FSHS,12,400 Moore ,Wildberry
This needs to be done as soon as possible, preference will be given based on price and how long it takes to finish. Please indicate when it will be completed to be considered.