XML Data Extraction and Transformation from GPS
Budget: $30 – $250 AUD
I have around 300,000 rows of data from our GPS system that I need to be processed. The data comes in XML format and needs to be transformed and exported to a single Excel sheet. Each asset's GPS data needs to be separated.
Key Requirements:
- Extract data from XML format: The data will need to be pulled from an XML source.
- Transform and Export: Longitude and latitude will need to be converted to an address for each transaction.
- Timestamp and Asset Numbers: These specific data fields also need to be included in the final output.
- Excel: All the processed data needs to be compiled into a single Excel sheet.
Ideal Skills:
- Proficiency in XML data handling
- Strong Excel skills
- Experience with data transformation and GPS data
- Knowledge of converting geographical coordinates to address
This project is ideal for a data specialist with experience in handling large datasets and GPS data.
Key Requirements:
- Extract data from XML format: The data will need to be pulled from an XML source.
- Transform and Export: Longitude and latitude will need to be converted to an address for each transaction.
- Timestamp and Asset Numbers: These specific data fields also need to be included in the final output.
- Excel: All the processed data needs to be compiled into a single Excel sheet.
Ideal Skills:
- Proficiency in XML data handling
- Strong Excel skills
- Experience with data transformation and GPS data
- Knowledge of converting geographical coordinates to address
This project is ideal for a data specialist with experience in handling large datasets and GPS data.