Take lists of bus data and extract by metro, outer metro and regional specific data.
Budget: $30 – $250 AUD
Data has been extracted from the web. The data is all in excel. I need someone with python or some similar skill to rearrange the data so it is easier to use and extract specific information. In this case, I would like to know per Australian State the total number of buses that operate Metro services, Outer metro services and regional services.
Then of those 3 categories, how many buses are 12.5-meter buses by extracting seating capacity within a range - 43 seating and 15 standing, so a total of 58 (so between 40 to 58/60 seats)?
Then of these how many operators are there in the three categories and who are they?
See attached picture of the table output I'm looking for + the data format + the number of sheets per workbook.
If you know your stuff it should not take more than 1 day. Please don't bid if you don't know how to do this but will try. I want people who know what to do.
Then of those 3 categories, how many buses are 12.5-meter buses by extracting seating capacity within a range - 43 seating and 15 standing, so a total of 58 (so between 40 to 58/60 seats)?
Then of these how many operators are there in the three categories and who are they?
See attached picture of the table output I'm looking for + the data format + the number of sheets per workbook.
If you know your stuff it should not take more than 1 day. Please don't bid if you don't know how to do this but will try. I want people who know what to do.