What will be the python code for this Assume that you are a data scientist in Amazon. Since the company is celebratingSilver Jubilee this year, it has decided to reward their customers. Your Managerhanded over last 2 years retail data and asked you to do certain tasks. The tasks areas follows:Task1-1:When you started working with data, you've realized that it needs cleaning toproduce better results.Do essential data cleaning. The final output should be the one as followsbefore cleaning: any negatives?: Trueafter cleaning: any negatives?: False In [19]:1 Datal.head(200)Out [19]:InvoiceNo StockCodeDescription QuantityInvoiceDate UnitPrice CustomerIDCountry53636585123AWHITE HANGING HEART T-LIGHT HOLDER01/12/2010 8:282.5517850 United Kingdom153636571053WHITE METAL LANTERN01/12/2010 8:263.3917850 United Kingdom253636584406BCREAM CUPID HEARTS COAT HANGER01/12/2010 8:262.7517850 United Kingdom353636584029G KNITTED UNION FLAG HOT WATER BOTTLE01/12/2010 8:263.3917850 United Kingdom453636584029ERED WOOLLY HOTTIE WHITE HEART.01/12/2010 8:263.3917850 United Kingdom19453838821115ROSE CARAVAN DOORSTOP401/12/2010 9:596.7516250 United Kingdom19553638822469HEART OF WICKER SMALL1201/12/2010 9:591.6518250 United Kingdom196536388222425 HOOK HANGER MAGIC TOADSTOOL1201/12/2010 9:591.6518250 United Kingdom19753638922941CHRISTMAS LIGHTS 10 REINDEER6 01/12/2010 10:038.5012431Australia19853638921822VINTAGE UNION JACK CUSHION COVER8 01/12/2010 10:034.9512431Australia199 rows x 8 columns

Assume that you are a data scientist in Amazon. Since the company is celebrating Silver Jubilee this year, it has decided to reward their customers. Your Manager handed over last 2 years retail data and asked you to do certain tasks. The tasks are as follows: Task1-1: When you started working with data, you've realized that it needs cleaning to produce better results. Do essential data cleaning. The final output should be the one as follows before cleaning: any negatives?: True after cleaning: any negatives?: False

Assume that you are a data scientist in Amazon. Since the company is celebrating Silver Jubilee this year, it has decided to reward their customers. Your Manager handed over last 2 years retail data and asked you to do certain tasks. The tasks are as follows: Task1-1: When you started working with data, you've realized that it needs cleaning to produce better results. Do essential data cleaning. The final output should be the one as follows before cleaning: any negatives?: True after cleaning: any negatives?: False

MIS

9th Edition

ISBN:9781337681919

Author:BIDGOLI

Publisher:BIDGOLI

Chapter3: Database Systems, Data Warehouses, And Data Marts

Section: Chapter Questions

Problem 6P

See similar textbooks

Similar questions

In Assignment 5, our focus was on the Data & Processes that act on it. This week’s assignment is focusing on Actions & Events. In a typical mobile banking application, users will login into the app, the log in may be successful or unsuccessful. For unsuccessful logins, the users can either request login or reset their password and attempt logging back in again. If the login is successful, the users can then perform various transactions (read actions). For example, The users can transfer money internally to another customer or transfer money to another account they own. They may also transfer money to an external bank. The users can also view their current account balance – they may have more than one account They can also deposit their check using Mobile Check deposit feature on the app They can contact customer service using either chat feature, request a callback, or email Some of the shapes and symbols you will need for this assignment are as follows: Start Point/Initial…
Which of the studied data structures in this course would be the most appropriate choice for the following tasks? And Why? To be submitted through Turnitin. Maximum allowed similarity is 15%. A Traffic Department needs to keep a record of random 3000 new driving licenses. The main aim is to retrieve any license rapidly through the CPR Number. A limited memory space is available. A symbol table is an important data structure created and maintained by compilers in order to store information about the occurrence of various entities such as variable names, function names, objects, classes, interfaces, etc. Symbol table is used by both the analysis and the synthesis parts of a compiler to store the names of all entities in a structured form at one place, to verify if a variable has been declared, …etc.
Datasets: Dataframes flights, airlines in the nycflights13 package. Other data can be integrated when needed. In this project, you will need to read in the given dataset in RStudio and then perform the following data analysis using R. Part I. Reading in the dataset and basic analysis Pat II. Visualizing relationships between pairs of variables Part III. Manipulating/ joining/ transforming Data Part IV. Summarizing data For each of the above four topics, please design 5 interesting questions/tasks, run R commands to get the answers or complete the tasks.
PLEASE SHOW ALL WORK AND COMMENT ALL CODE The Objective of this coding problem is the prediction of a proposed metro ectension construction project based on the people'es opinion. There are three alternatives to choose they are as follows: Eglington-Pickering Line Airport-Vaughn Line Airposrt-Hamilton Line Each record is represented by 16 features. Task-1: Metro-Ext.xlsx is the training and test dataset; you will considerr 80% of the data for training and 20% for the test. Build (1) Logistic regression (2) KNN and (3) Naive Bayes model to predict on the test data set and compute the confusion matrix for each model and compare the result. deliverables = coding files (.py and .ipynb), and a discussions of confusion matrix for both models metro-EXT.xlsx (Please place chart in EXCEL) Feasibility and Constructability Slopes and Gradients Urban Realm Geology and Soil Stability Land Acquisition Work Opportunities Economy in Movement of People Revenue Generation Access to the Social,…
This question tests your understanding of data transformation. We did an assignment on this process. If you test your data and find that it is not suitable for testing, which mathematical function can you put each score through to make it usable and suitable for testing? Select one: a. There is no way to make the data usable. b. square root each number c. subtract the df from each number d. use the variance instead of each number Clear my choice
PHP According to table the in the image 1. (Assume that the following program section (Program Code 1) are variables that receives input from the user via a form. Build program code to provide instructions for entering the data into the assessments table. In addition, next build a link to view the data that has been entered.) <?php include ('config.php'); $ matrixnum = $_POST['matrixnum']; $ subject_code = $_POST['subject_code ']; $ quiz = $_POST['quiz']; $ assignment = $_POST['assignment']; $ project = $_POST['project']; $ total_marks= $_POST['total_marks']; $ grade = $_POST['grade']; Code program 1 2.(Based on the program section (Code Program 1), assume that the data wants to be updated by the user. Build program code to provide instructions for updating the data to the assessments table. In addition, build a link to view the updated data.)
The following is a sample report from a child clinic. It shows the days and treatments for visits to doctors at the clinic. A mother takes her child, sees a doctor and the doctor administers some treatment. There are couple of things you should assume: The mother’s name is unique. a mother won't have more than one child with the same name the doctor's surname is unique a treatment code is unique treatments are specific to doctors, eg 101 is only ever given by Johnson Surname First Name Town Age Child Doctor Date Treatment Smith Jane Coventry 30 Rebecca Johnson 27.3.04 101 Brian Clarence 30.5.04 209 Robert Johnson 10.1.88 101 Brown Beryl Rugby 28 Alan Clarence 30.4.04 214 Sarah Johnson 29.5.04 101 Sarah Clarence 12.1.04 321 Jones Fiona Kenilworth 34 James Clarence 30.4.04 322 Jenny…
_&plase helo with Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers..
Using R lab please provide the code and answer:Find the data set “HELPrct”. Construct a side by side boxplots (can be horizontal orvertical) to compare the effect of homeless or housed on the average number of drinks perday for the patients. Add title “XXXXXX – Side by side Boxplot to compare the effect ofhomeless on average number ofDrinks”.Based on the side by side boxplot; write a simple conclusion.Find the data set “HELPrct”. Construct a side by side boxplots (can be horizontal orvertical) to compare the effect of different race groups on the average number of drinksper day for the patients. Add title “XXXXXX – Side by side Boxplot to compare the effectof race groups vs on averagenumber of Drinks”.Based on the side by side boxplot; write a simple conclusion.
The following statement tells the decomposition of the people survived a.k.a column Survived as of 0 (not survived) or 1 (survived). Create a similar statement using groupby function to further breakdown by Sex. In other words, add additional sex dimension. The desired output should be similar to the following: Sex Survided female 0 81 1 233 male 0 468 1 109Name: Survived, dtype: int64 In [16]:
Consider a school system in which data is recorded about the movie industry. The data requirements are summarized as follows: Each subject is owned by a department and each department ismanaged by a teacher, called Head of Department (HOD). Eachdepartment has a name and a unique code number. Each subjecthas a name, unique number and credit value. All teachers have aunique ID. A HOD cannot manage more than one department at atime. Also, a HOD does not teach subjects. A subject cannot betaught by more than one teacher. Finally, the system needs toknow each student’s contact details, including, full name, studentID, address, age and gender, as well as date of enrolment in thesubject. Design an Entity-Relationship diagram for the movie database
Your department is interested in keeping track of crucial information. Create a data structure that will keep important information for your department. Of course, the list of majors should be sorted by last name (and then by first, if there are multiple students with the same last name).Your department is interested in keeping track of crucial information. Create a data structure that will keep important information for your department. Of course, the list of majors should be sorted by last name (and then by first, if there are multiple students with the same last name).