Find Jobs
Hire Freelancers

Python script xls to sql + optional php

$30-250 USD

In Progress
Posted almost 9 years ago

$30-250 USD

Paid on delivery
The project is divided in two part: 1) Python Script -> Read an Excel File: all the sheets (see attachment) -> the sheets have this format [login to view URL]:variableName -> [login to view URL] can have several variables in the example is only three (F_B1_H , F_B2_H, F_B3_H) but the script should be able to group for each [login to view URL] all the variables please note that the variable name i.e: F_B1_H are not the real one so the script should work with any variableName. -> the two values per each sheet are important: the timestamp and the value (see example) -> Create a single Excel Sheet with all the values and with an header for each [login to view URL]:variablename -> connect to a mysql database -> create tables named SURNAME for each SURNAME in the excel (create if not exist) -> create fields in each table caleld variableName (in the example F_B1_H , F_B2_H, F_B3_H) -> add (append) the timestamp and the value to a new row for each table as found in the excel file 2) Php + bootstrap Nice visualization of the data from the SQL database each SURNAME with all the values recorded specify if in the bid you think you can use a chart javascript such as [login to view URL] to graph the timeseries for each SURNAME
Project ID: 7978676

About the project

6 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I have an extensive programming background and I'm very skilled with python, so I can provide good quality code. I have also experience with PHP and web technologies so I can handle the frontend task as well. I read and write English fluently. I have worked with js charting libraries like highcharts I can work with the referred one as well.
$100 USD in 7 days
5.0 (16 reviews)
3.9
3.9
6 freelancers are bidding on average $197 USD for this job
User Avatar
I would like to apply this job, My experience of 5 years in development and my implementation power keeps me one step ahead for working with any web based application with a very high speed. I am pro with PHP, Zend, Wordpress, & CakePHP and other related technologies. Why me? I believe in Pro active communication and quality delivery. I ensure you that I will satisfy with my work. We can discuss more over chat. Thanks
$250 USD in 5 days
5.0 (55 reviews)
6.2
6.2
User Avatar
A proposal has not yet been provided
$150 USD in 5 days
5.0 (11 reviews)
3.3
3.3
User Avatar
Hello, my name is Enrique and i can provide you a solution for your needs. Do you have any special requirements for the software versions ? The php need to be made using Bootstrap ? Just registered few days ago so i'm looking forward to close this deal to make you my first client in this portal :) Best regards,
$144 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm experienced programmer with strong knowledge of python, javascript. I need about 3 days into first part and time to learn FLOT.js.
$120 USD in 14 days
0.0 (1 review)
0.0
0.0

About the client

Flag of SWITZERLAND
naples, Switzerland
5.0
4
Payment method verified
Member since Nov 16, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.