Closed

Python wrapper classes to database - No Asian

I am looking to create Python classes that read a specific schema from any database. I will provide you the scheme, it contains about 23 tables. The classes must be able to read from an H2 database. The data is read on every invocation of a method that reads a particular table. The method will load the data into a pandas DataFrame and return it.

In addition, I am looking for charting capabilities using matplotlib. There will be 5 charts that will need to be created using data from these 23 tables.

This will be packaged as an importable library. We'll call this library pycordence. Here is some representative Python code on how these classes should work. Imagine there are 15 tables, TABLE1..TABLE15

import pycordence

node = Node (url,username,password) # Connects to a database

df = node.get_table1() # Retrieves the data from TABLE1, puts it into a DataFrame and returns

print(df)

df = node.get_table2() #Does same for TABLE2...

node.display_stat1() # Displays a matplotlib chart using data from the 23 tables

Requirements:

- Must use Python 3, latest version major / minor version

- Adhere to well established Python naming conventions

- Must use pandas. Additional SQL libraries are allowed (i.e. SQLAlchemy, NumPy) but methods must return DataFrames

- Must connect to H2 database (I found this to not be easy, Postgres drivers may fail)

- Must be packaged so that it can be rolled out and pip'd by others

- All source code must be documented completely

- A README must be provided with notes on how to use, any potential issues

I will provide the database schema after I select the right person for this job.

Skills: Data Mining, MySQL, Python, Software Architecture, Web Scraping

See more: python parse file database, database management design job, creator wrapper classes, resume database administrator sql job jobs, actuate report wrapper classes developed vbnet, python webcrawler mysql database, python querying whois database, wrapper classes writting win32dll, students classes database, error database selected cron job, database data entry job, need wrapper classes, mfc wrapper classes used, database administrator getafreelance job, database design access job, database design consideration job portals, database development outsourcing job, python parse wikipedia database, python read dump database

About the Employer:
( 0 reviews ) Vladivostok, Russian Federation

Project ID: #19969826

7 freelancers are bidding on average $160 for this job

zekovicm

Hi there,I am Python expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agree More

$210 USD in 4 days
(100 Reviews)
7.3
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$180 USD in 4 days
(76 Reviews)
6.7
naseeb1995

Hi, I am a Computer Engineer and a Full Stack Django Developer with an extensive experience of 5 years in development. I am an expert in Web Scraping, and develop scrapers in Python Programming Language. Unlike some More

$140 USD in 7 days
(1 Review)
1.8
myappsdevelopers

Hello Hiring Manager, I read your job descriptions carefully, I am very interesting in your job. I have developed apps such as Social networking & lifestyle(Tinder style dating, chatting, sharing), Food & drink(Rest More

$225 USD in 15 days
(1 Review)
1.3
Habarpapa

Hello, my name is Aleksandr I am Computer engineering student from Technion- IIT, Israel currently working as developer in DataAnalysis lab in Technion, native Russian speaker, буду рад обговорить детали задачи и надею More

$222 USD in 10 days
(0 Reviews)
0.0
piyush4531

Experienced python developer

$111 USD in 4 days
(0 Reviews)
0.0
bigD24

I will be able to complete this, sounds like a simple job, I have extensive experience working with python 3 and will be able to package it into a lib.

$30 USD in 7 days
(0 Reviews)
0.0