Write a python script to read in the csv files

Assignment Help Python Programming
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.

Reference no: EM133361362

Questions Cloud

How to use the information system some fields were required : Identify issues with the implementation. Did the physicians make the right decision in going back to paper? how to use the information system Some fields
Why does marriage between people called first cousins : Why does marriage between people called "first cousins" occur within societies practicing Iroquis kinship?
Does the cultural behavior of chimpanzees provide : ANT 2000 Miami Dade College, Kendall Does the cultural behavior of chimpanzees provide any insight - explain the unique presence of these cultural behaviors
What is importance of using and viewing the nclex-rn test : What is the importance of using and viewing the NCLEX-RN test plan? Is there a difference between the NCLEX-RN test plan and the NCLEX-RN Candidate Bulletin?
Write a python script to read in the csv files : The data in the csvWrite a python script to read in the csv files and populate a relational database such as SQ Llite.
What are the significance and concerns when we consider : handful of speakers and many more that no longer exist. What are the significance and concerns when we consider this loss
Examine the role of regional blocs in the global economic : Discuss the relevance of Bretton Woods institutions such as the IMF and the World Bank in the current global context and Examine the role of regional blocs
Discuss one design or type of quantitative study : Discuss one design or type of quantitative study, then tell us how would you determine the level of evidence that this type of quant. design generates.
What are the priority considerations to be addressed : What are the priority considerations to be addressed? Considering the circumstances, what is the optimal nurse staffing skill mix? What metric/tool would you

Reviews

Write a Review

Python Programming Questions & Answers

  Write a python program to implement the diff command

Without using the system() function to call any bash commands, write a python program that will implement a simple version of the diff command.

  Write a program for checking a circle

Write a program for checking a circle program must either print "is a circle: YES" or "is a circle: NO", appropriately.

  Prepare a python program

Prepare a Python program which evaluates how many stuck numbers there are in a range of integers. The range will be input as two command-line arguments.

  Python atm program to enter account number

Write a simple Python ATM program. Ask user to enter their account number, and print their initail balance. (Just make one up). Ask them if they wish to make deposit or withdrawal.

  Python function to calculate two roots

Write a Python function main() to calculate two roots. You must input a,b and c from keyboard, and then print two roots. Suppose the discriminant D= b2-4ac is positive.

  Design program that asks user to enter amount in python

IN Python Design a program that asks the user to enter the amount that he or she has budget in a month. A loop should then prompt the user to enter his or her expenses for the month.

  Write python program which imports three dictionaries

Write a Python program called hours.py which imports three dictionaries, and uses the data in them to calculate how many hours each person has spent in the lab.

  Write python program to create factors of numbers

Write down a python program which takes two numbers and creates the factors of both numbers and displays the greatest common factor.

  Email spam filter

Analyze the emails and predict whether the mail is a spam or not a spam - Create a training file and copy the text of several mails and spams in to it And create a test set identical to the training set but with different examples.

  Improve the readability and structural design of the code

Improve the readability and structural design of the code by improving the function names, variables, and loops, as well as whitespace. Move functions close to related functions or blocks of code related to your organised code.

  Create a simple and responsive gui

Please use primarily PHP or Python to solve the exercise and create a simple and responsive GUI, using HTML, CSS and JavaScript.Do not use a database.

  The program is to print the time

The program is to print the time in seconds that the iterative version takes, the time in seconds that the recursive version takes, and the difference between the times.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd