Completed

Python Programming

This assignment involves writing Python code to extract information about product details

from data files and load them into a consistent SQL database. It is an

example of an Extract-Transform-Load (ETL) task.

You have been given the task of generating some normalised data on product given some

data files in different formats.

You are given:

* An HTML file that lists information about products, stock, and prices.

* A CSV spreadsheet containing information about users.

* A CSV spreadsheet containing detailed information about orders. This spreadsheet contains columns for

the product id number and the user id number along with the order quantity.

The fake CSV data was generated using [Mockaroo]([login to view URL]).

Your task is to read the data from all of these files, add it into an SQL database,

and operate on the database to produce a report.

The schema for the SQL database is provided for you in the file database.py. You can

run this file to create the database. Your code will then add data to it. Note that

the HTML file lists the product ID as part of the HTML `href` attribute. This is the

ID that needs to be used to populate the `products` table in the database.

## Useful Python Modules

Python has many useful modules for this task. You will want to look at:

* the __csv__ module for reading and writing CSV files.

* the __bs4__ module (BeautifulSoup) for reading HTML files.

And of course you will use the __sqlite3__ module for handling the database.

## Required Output

Your file `[login to view URL]` needs to generate a CSV file containing a report on the

orders. The CSV file must contain the following fields:

* `id`: User ID

* `first_name`: User first name

* `last_name`: User last name

* `product`: Product ID number

* `description`: Product description

* `quantity`: the order quantity

* `price`: the order unit price

* `total`: the total for the order (`quantity` * `price`)

In addition, the report must be sorted in alphabetical order of user last name.

The template `[login to view URL]` includes several functions that you **must** implement as part of your

solution. Each is described in the doc string. The script calls the function `main` which

should do all of the work of reading the data files and generating the report.

The file `[login to view URL]` contains a set of unit tests for all the functions in `[login to view URL]`. Your

code should pass all of these tests. Note that I will change the data files so your code should not assume that any part of the data is the same as in these

files.

- Passing all automated tests:

- Manual assessment of the code quality:

- Manual assessment of documentation:

Code quality means well laid out code, good use of variable names, functions and use of appropriate

control flow and data structures.

Documentation means that all functions that you write have suitable docstrings (e.g. keep the docstrings

provided in [login to view URL]) and where appropriate you use comments in your code to explain yourself.

Skills: Python, MySQL, PostgreSQL, SQL, HTML5

See more: bid python programming projects, free programming change management template, smarty template alphabetical order, python programming pdf, python programming examples, python programming for the absolute beginner, what is python used for, python download, learn python, python programming app, python software, python programming web bot project website, programming constant contact template, smarty template alphabetical listing, crawl webpage webpage automatically python programming, programming project log template, rapidshare python programming introduction computer science, python programming karachi, openerp python programming, python programming arcgis

About the Employer:
( 1 review ) MARSFIELD, Australia

Project ID: #21352948

Awarded to:

garethbill

Hello sir. I am Python and MySQL expert. **My Bid is not luxury** I have read your description carefully and understand. I also have keen skill in HTML5 and PostgreSQL. So I am suitable for your project. I wish work wi More

$80 AUD in 7 days
(18 Reviews)
5.0

12 freelancers are bidding on average $124 for this job

liveexperts123

………..…………………………………………………………………………………………………………………………………………………………………………………………………………………………………..………..…………………………………………………………………………………………………………………………………………………………………………………………………………………………………..

$390 AUD in 7 days
(16 Reviews)
5.9
valor312

How are you? ⭐⭐⭐ I can complete your project in 1 day ⭐⭐⭐ Thanks for your project suggestion. Python is my main program skill of all. ------------------------------- https://www.freelancer.com/projects/software-archite More

$80 AUD in 1 day
(41 Reviews)
5.6
junaidlodhi6

Greetings there... i can do this task... let me know if it is not a educational work only then... looking forward to hearing from you... thanks!

$100 AUD in 7 days
(33 Reviews)
5.3
umg536

Hi there, please leave a message on my chat so we can discuss the budget and deadline of the project. I have read your project description and i'm confident i can do this project for you perfectly. Thanks . .

$120 AUD in 3 days
(9 Reviews)
4.9
wwwTom

Hi sir Thanks for your posting job. I am interested in your project. Please see my profile Then you can notice that I am a top c++ developer. And I have experience in cryptocurrrency. I will do my best. Best Regards

$100 AUD in 7 days
(8 Reviews)
4.5
greenguru2018

Hello, How are you? My pleasure to bid your project. I've read carefully your project description. I have more than five years experience in development related with your project. Your satisfaction with the project is More

$100 AUD in 7 days
(15 Reviews)
4.4
topexpert713

Hi, Nice to meet you! I am very interesting your project and I am confident of I can help your job. I am confident of this project as I'm a professional Python expert with over 7 years of experience. Seems to be an in More

$100 AUD in 3 days
(15 Reviews)
4.4
yongan20151117

Hello Sir. How are you. I am dataplatform expert for dataprocessing on cloud service system. ETL is one of My Top Skill. My Skill is ETL,MDM,Talend , hotonworks, MYSQL,ORAClE and Jenkins ,Devopts. Programming language More

$120 AUD in 1 day
(7 Reviews)
3.8
IshaqKN

Hi there, I can complete your assignment; no problem; just call me out. Best regards, Ishaq Relevant Skills and Experience Python, Data Processing, SQL

$90 AUD in 4 days
(4 Reviews)
3.6
codestar0714

Hello Sir! I am working for a cloud team that provides technical supports and services for many enterprises in china. Strong analytical and problem solving skills. Fluent in OOP, design patterns, full stack web progra More

$100 AUD in 1 day
(4 Reviews)
2.5
chandrubadiger

Hi, this work is part of my daily life activity in the project. My code would be more readable and efficient. Relevant Skills and Experience Having 6 years of python experience.

$111 AUD in 5 days
(0 Reviews)
0.0