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


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

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


- 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.

Квалификация: Интеллектуальный анализ данных, MySQL, Python, Архитектура ПО, Веб-скрейпинг

Показать больше 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

О работодателе:
( 0 отзыв(-а, -ов) ) Vladivostok, Russian Federation

ID проекта: #19969826

7 фрилансеров(-а) в среднем готовы выполнить эту работу за $160


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 Больше

$210 USD за 4 дней(-я)
(100 отзывов(-а))

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 Больше

$180 USD за 4 дней(-я)
(76 отзывов(-а))

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 Больше

$140 USD за 7 дней(-я)
(1 отзыв)

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 Больше

$225 USD за 15 дней(-я)
(1 отзыв)

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, буду рад обговорить детали задачи и надею Больше

$222 USD за 10 дней(-я)
(0 отзывов(-а))

Experienced python developer

$111 USD за 4 дней(-я)
(0 отзывов(-а))

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 за 7 дней(-я)
(0 отзывов(-а))