Reference no: EM133361362
Assignment:
Write a python script to read in the comma separated value files and populate a relational database such as SQ Llite. The data in the csvWrite a python script to read in the csv files and populate a relational database such as SQ Llite. The data in the comma separated value files may have missing or incorrect values. Discuss how you cleaned up the data.
Write a GUI interface, using for example Tkinter, to update the manager of a specific store to the database. The code should check that the email is in the correct format: [email protected] where xxx and yyy are strings of letters.
Demonstrate that the information about the new manager has been correctly added to the database by including a screenshot.
Develop an additional GUI that has buttons to do the following analysis after the data has been extracted from the database using SQL.
- Calculate the mean store size for each of the types of stores "A", "B", and "C" and print them out.
- Draw a series of sales versus date for a specific store and department. The GUI should input the store number and department number and draw the appropriate time series.
Provide screen-shots to show the statistical analysis part of the GUI workingiles may have missing or incorrect values. Discuss how you cleaned up the data.
Write a GUI interface, using for example Tkinter, to update the manager of a specific store to the database. The code should check that the email is in the correct format: [email protected] where xxx and yyy are strings of letters.
Demonstrate that the information about the new manager has been correctly added to the database by including a screenshot.
Develop an additional GUI that has buttons to do the following analysis after the data has been extracted from the database using SQL.
- Calculate the mean store size for each of the types of stores "A", "B", and "C" and print them out.
- Draw a series of sales versus date for a specific store and department. The GUI should input the store number and department number and draw the appropriate time series.