Python - Import JSON Data from API to CSV format with Excel calculation (Correlation Formula)
$12-30 SGD
Paiement à la livraison
This is a small project to import Stock Data of 1 stock with date range, say 1 year (JSON format) from an API using Python and convert the data to a file in csv format. This stock data (1 year~) should be present in 1 csv file.
The JSON data stored in this csv file, (retrieved from the API) will contain 3 main columns. Opening price and Closing price and Date. You will create 3 more columns "Previous Day - Current Day Opening Price" and "Opening price - Closing Price" and "Closing Price previous day - Current day opening price". Based on these three columns, you will use the excel formula CORREL() and give an output to see if there is a correlation between these 3 columns.
The python script should be able to automate this for 2500 stocks. So, about 2500 csv files will be created.
Finally, the script should create 1 main csv file containing the correlation data with all the 2500 stocks.
Additionally with the 3 columns in the csv file, there has to be 4 more columns based on simple subtraction and addition of the 3 columns. Details are added in the project description file attached.
Nº du projet : #16390090
À propos du projet
Décerné à:
Hello. I am an expert in importing, manipulating, and storing data in all formats. I am a senior python developer and I'm looking to do an excellent job as my first project, which happens to be yours. You can expect Plus
14 freelances font une offre moyenne de 30 $ pour ce travail
Dear sir As a python developer, I am confident with this job and can start the work right now. Looking forward to hearing from you soon. Best, Jiang
Hello, * Excellent with Python & Related Frameworks * Excellent with Product Development * Excellent with Python Front-End * Excellent 8 Years ERP Development Experience * Excellent 12 Year Experience P Plus
I have spent over two years working at a financial research firm as a data analyst using Python and Excel to automate the collection, validation and analysis of data from various sources. What you are requesting--getti Plus
I have much fluency in python, apis, json and operating csv files. I believe in delivering work on time with full customer satisfaction.
It is an easy problem and can be easily done using pandas. I have asked for a very small amount as this will be my first project in Freelancer and I need to build my profile. Hope it is a good deal for you as well. Plus
1. Maximum support after I finish this project 2. I do because of the responsibility and the value you will pay me