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.
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 agreed deadline.
Check out my profile and former clients feedback - that'll let you know everything about me.
Please feel free to contact me so that we can discuss further details.
Thank you for taking the time to read my proposal.I am looking forward to hearing from you.
Best regards,
Miljan
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.
Please visit : https://www.freelancer.com/u/schoudhary1553
I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
Kinds Regards,
Sandeep
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 developers who scrape data using GUI tools, I will develop scrapers in Python language using Requests and LXML modules, and will make the code completely robust and reliable by adding all the exceptional handling codes required.
I can also develop an API for the scrapers, so that you can implement the code in whatever programming language you are using for your backend.
Please reply, so that we can discuss this further.
Thanks
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, буду рад обговорить детали задачи и надеюсь вы примете взвешенное решение)
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.