Python Specialist for Customer Data Analysis
Budget: $30 – $250 USD
I am presently in need of a experienced Python developer for a project centered around Data Analysis, specifically focusing on Financial Data. Your responsibility will be to write a Python script on the dataset provided.
Key responsibilities:
- Reading from Excel or other data files and process them into Python data objects (such as a dictionary)
- Write the code to process data as fast as you can
- Interpret complex customer data, analyze results using statistical techniques
- Develop and implement data collection systems and other strategies for predictive analysis
- Assuring the quality of the data used for analysis is optimal
- Building algorithms and developing automated processes
- Test and QA the software you write and assist with integration if required
Ideal Skills and Experience:
- Proven experience in Python development
- Rigorous understanding of data analysis methodologies
- In-depth experience with handling and interpreting customer data
- Proficiency in predictive analysis techniques
- Experience in creating automated processes
- Outstanding data cleaning skills
Task 1:
Write a Python script that implements a function: get_my_data(symbol, date) where symbol is a string and date is in format yyyy-mm-dd
1) the directory contains a large number of CSV files that are named like: data20210315.csv
2) there are thousands of rows in the CSV file and each row is to be processed and put into a large dictionary indexed by [date][symbol] for example AllData['2021-03-15']['AALBF']
and the next level of keys and values
one example of a row is:
20210315|AALBF|Aalberts Industries NV Ordinar|S|OTC|45227|54284||0|999.99||-16.68|-9057|2019-12-31
you should turn this into a dictionary entry with consistent keys I will be giving.
3) all the CSV files should be processed to create one dictionary that has all the data, and a Pickle dump file.
4) when the function is called, it should look for an entry that has a date equal to or immediately prior to the date given... i.e. when called get_my_data('AALBF','2021-03-17'),
you should return the value in AllData['2021-03-15']['AALBF'] as that is the one with a date before 2021-03-17 and then under symbol 'AALBF'
(not: there is no file named data20210317.csv and data20210316.csv)
The appropriate candidate should also be detail-oriented and have a knack for translating data into easily comprehensible formats. Your main goal will be to aid our team in making data-informed decisions.
THIS IS A SMALL AND RATHER SIMPLE TASK WITHIN A LARGE PROJECT AND I EXPECT TO COLLABORATE WITH YOU MORE IF GOOD RESULT IS ACHIEVED.
Key responsibilities:
- Reading from Excel or other data files and process them into Python data objects (such as a dictionary)
- Write the code to process data as fast as you can
- Interpret complex customer data, analyze results using statistical techniques
- Develop and implement data collection systems and other strategies for predictive analysis
- Assuring the quality of the data used for analysis is optimal
- Building algorithms and developing automated processes
- Test and QA the software you write and assist with integration if required
Ideal Skills and Experience:
- Proven experience in Python development
- Rigorous understanding of data analysis methodologies
- In-depth experience with handling and interpreting customer data
- Proficiency in predictive analysis techniques
- Experience in creating automated processes
- Outstanding data cleaning skills
Task 1:
Write a Python script that implements a function: get_my_data(symbol, date) where symbol is a string and date is in format yyyy-mm-dd
1) the directory contains a large number of CSV files that are named like: data20210315.csv
2) there are thousands of rows in the CSV file and each row is to be processed and put into a large dictionary indexed by [date][symbol] for example AllData['2021-03-15']['AALBF']
and the next level of keys and values
one example of a row is:
20210315|AALBF|Aalberts Industries NV Ordinar|S|OTC|45227|54284||0|999.99||-16.68|-9057|2019-12-31
you should turn this into a dictionary entry with consistent keys I will be giving.
3) all the CSV files should be processed to create one dictionary that has all the data, and a Pickle dump file.
4) when the function is called, it should look for an entry that has a date equal to or immediately prior to the date given... i.e. when called get_my_data('AALBF','2021-03-17'),
you should return the value in AllData['2021-03-15']['AALBF'] as that is the one with a date before 2021-03-17 and then under symbol 'AALBF'
(not: there is no file named data20210317.csv and data20210316.csv)
The appropriate candidate should also be detail-oriented and have a knack for translating data into easily comprehensible formats. Your main goal will be to aid our team in making data-informed decisions.
THIS IS A SMALL AND RATHER SIMPLE TASK WITHIN A LARGE PROJECT AND I EXPECT TO COLLABORATE WITH YOU MORE IF GOOD RESULT IS ACHIEVED.