Question
You are given four training datasets in the form of csv-files. Your Python program needs to be able to independently compile a SQLite database (file)
You are given four training datasets in the form of csv-files. Your Python program needs to be able to independently compile a SQLite database (file) ideally via sqlalchemy and load the training data into a single five-column spreadsheet / table in the file. Its first column depicts the x-values of all functions. Table 1, at the end of this subsection, shows you which structure your table is expected to have. The fifty ideal functions, which are also provided via a CSV-file, must be loaded into another table. Likewise, the first column depicts the x-values, meaning there will be 51 columns overall. Table 2, at end of this subsection, schematically describes what structure is expected. After the training data and the ideal functions have been loaded into the database, the test data (B) must be loaded line-by-line from another CSV-file and if it complies with the compiling criterion matched to one of the four functions chosen under i (subsection above). Afterwards, the results need to be saved into another four-column-table in the SQLite database. In accordance with table 3 at end of this subsection, this table contains four columns with x- and y-values as well as the corresponding chosen ideal function and the related deviation. Finally, the training data, the test data, the chosen ideal functions as well as the corresponding / assigned datasets are visualized under an appropriately chosen representation of the deviation. Please create a Python-program which also fulfills the following criteria: Its design is sensibly object-oriented It includes at least one inheritance It includes standard- und user-defined exception handlings For logical reasons, it makes use of Pandas packages as well as data visualization via Bokeh, sqlalchemy, as well as others Write unit-tests for all useful elements Your code needs to be documented in its entirety and also include Documentation Strings, known as docstrings
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started