Mistakenly wrote the accounting in subject but the subject is Data science
Tusk Eee Purchases In this Exercise you will be given some Fake Dus about compucho done through Amana! Feel free to defence the solution. Most of the triks can be sohad in different way for the mout, the question Plone excuse anything that doesn't make a Wome in the detall the data is fake and made Also note that all of these questions can be answered with one line of code 1. Import pandas sad read in the commerce Purchases es file II. Check the head of the Dataframe called.com III. How many news and comes are there? 1. What is the verge Purchase Price What were the highest and lowest purchase prices! VI. Hon many people have English as their Language of VIL How many pople have the job title of "Lawyer" VIII How many people made the pershaw during the AM and how many people made the purchase during PM IX. (Hint: Cheek aflat X What are the come Job Titles XI Semicone made a purchase that came from Lot 90 WT". what was the Purchase price for this traction XIL What is the email of the person with the following Credit Card Number: 024625343672853 XII. How many people have American Express as their Credit Card Provider and made a perchase aheve ? XIV. Hard: How many people have a credit card that expires in XV Mard: What are the top most popular email provides hosts (eemail.com, yahoo.com, 20257 Task 2: SF Salaries Welcome to a quick se for you to practice you and killed We will be using the SE Saladi. Dati from Kaydet Just follow alone and complete the tanks outlined in bold below. The tanks will hender best Read Salaries.cs as a dataframe called sal. Use the lafemethod to find out how many entries there are What is the highestament of ChertimePay in the dataset Le match w What the job title of JOSEPH DRISCOL.L. Natet Use all How much does JOSEPH DRISCOLI make (including What is the name of highest paid person including benefits? What is the name of lowest paid person including benefits Deyounike omething ring about how much he or she is paid? What was the average mean) BasePay of all employees per How many unique job titles are there? What are the top most commojas low many Job Titles were represented by only one person in 2013 (eg. Job Titles with only one eccurrence in 2013?) Honny people have the word Chlef in their job title? (This is pretty tricky V Buss there a correlation betwee length of the Job Title string and Salary year? (2011-2014) BRANI Data Science Technologies (Data Engineering: Numpx and Pandas) Assignment #3 Due Date: 28-04-2021 Task 1 Ecommerce Purchases In this Exercise you will be given some Fake Data about some purchases done through Amazon! Feel free to reference the solutions. Most of the tasks can be solved in different ways. For the most part, the questions get progressively harder Please excuse anything that doesn't make "Real-World" sense in the dataframe all the data is fake and made up Also note that all of these questions can be answered with one line of code 1 Import pandas and read in the Ecommerce Purchases csv file and set it to a DataFrame called esom. II. Check the head of the DataFrame. III How many rows and columns are there? IV What is the average Purchase Price? V What were the highest and lowest purchase prices? VI How many people have English 'en' as their Language of choice on the website? VII How many people have the job title of "Lawyer" 2 VIII How many people made the purchase during the AM and how many people made the purchase during PM 2 (Hint: Check out value countso) X What are the 5 most common Job Titles? XI Someone made a purchase that came from Lot: "90 WT", what was the Purchase Price for this XII What is the email of the person with the following Credit Card Number: 4926535242672853 XIT How many people have American Express as their Credit Card Provider and made a purchase above $952 Hard: How many people have a credit card that expires in 2025? Hard: What are the top 5 most popular email providers/hosts (exgmail.com, yahoo.com, etc...) IX wvwmm xm wwww transaction? XIV XV (Data Engineering: Numpy and Pandas) Assignment #3 Due Date: 28-04-2021 Task 1 Ecommerce Purchases In this Exercise you will be given some Fake Data about some purchases done through Amazonl Feel free to reference the solutions. Most of the tasks can be solved in different ways. For the most part, the questions get progressively harder Please excuse anything that doesn't make "Real-World" sense in the dataframe, all the data is fake and made up Also note that all of these questions can be answered with one line of code I. esom II III IV V VI VII VIII Import pandas and read in the Ecommerce Purchases csv file and set it to a DataFrame called Check the head of the DataFrame. How many rows and columns are there? What is the average Purchase Price? What were the highest and lowest purchase prices? How many people have English 'en' as their Language of choice on the website? How many people have the job title of "Lawyer"? How many people made the purchase during the AM and how many people made the purchase during PM (Hint: Check out value..count) What are the 5 most common Job Titles? Someone made a purchase that came from Lot: "90 WT" what was the Purchase Price for this transaction? What is the email of the person with the following Credit Card Number: 4926535242622953 How many people have American Express as their Credit Card Provider and made a purchase above $952 Hard: How many people have a credit card that expires in 2025? Hard: What are the top 5 most popular email providers/hosts (@g_gmail.com, yahoo.com, etc...) IX X XI XII XIII XIV XV Task 2: SF Salaries I II IV. V. Welcome to a quick exercise for you to practice your pandas skills! We will be using the SF Salaries Dataset from Kaggle! Just follow along and complete the tasks outlined in bold below. The tasks will get harder and harder as you go along, Import pandas as pd. Read Salaries.csv as a dataframe called sal. Check the head of the DataFrame. III Use the info() method to find out how many entries there are. What is the average BasePay ? What is the highest amount of OvertimePay in the dataset. 2 VI What is the job title of JOSEPH DRISCOLL 2 Note: Use all caps, otherwise you may get an answer that doesn't match up (there is also a lowercase Joseph Driscoll). VII How much does JOSEPH DRISCOLL make (including benefits)? What is the name of highest paid person (including benefits)? What is the name of lowest paid person (including benefits)? Do you notice something strange about how much he or she is paid? What was the average (mean) BasePax of all employees per year? (2011-2014)_2 XI How many unique job titles are there? What are the top 5 most common jobs? XIII How many Job Titles were represented by only one person in 2013? (eg. Job Titles with only one occurrence in 2013?) How many people have the word Chief in their job title? (This is pretty tricky) XV Bonus: Is there a correlation between length of the Job Title string and Salary? VIII IX X XII XIV Tusk Eee Purchases In this Exercise you will be given some Fake Dus about compucho done through Amana! Feel free to defence the solution. Most of the triks can be sohad in different way for the mout, the question Plone excuse anything that doesn't make a Wome in the detall the data is fake and made Also note that all of these questions can be answered with one line of code 1. Import pandas sad read in the commerce Purchases es file II. Check the head of the Dataframe called.com III. How many news and comes are there? 1. What is the verge Purchase Price What were the highest and lowest purchase prices! VI. Hon many people have English as their Language of VIL How many pople have the job title of "Lawyer" VIII How many people made the pershaw during the AM and how many people made the purchase during PM IX. (Hint: Cheek aflat X What are the come Job Titles XI Semicone made a purchase that came from Lot 90 WT". what was the Purchase price for this traction XIL What is the email of the person with the following Credit Card Number: 024625343672853 XII. How many people have American Express as their Credit Card Provider and made a perchase aheve ? XIV. Hard: How many people have a credit card that expires in XV Mard: What are the top most popular email provides hosts (eemail.com, yahoo.com, 20257 Task 2: SF Salaries Welcome to a quick se for you to practice you and killed We will be using the SE Saladi. Dati from Kaydet Just follow alone and complete the tanks outlined in bold below. The tanks will hender best Read Salaries.cs as a dataframe called sal. Use the lafemethod to find out how many entries there are What is the highestament of ChertimePay in the dataset Le match w What the job title of JOSEPH DRISCOL.L. Natet Use all How much does JOSEPH DRISCOLI make (including What is the name of highest paid person including benefits? What is the name of lowest paid person including benefits Deyounike omething ring about how much he or she is paid? What was the average mean) BasePay of all employees per How many unique job titles are there? What are the top most commojas low many Job Titles were represented by only one person in 2013 (eg. Job Titles with only one eccurrence in 2013?) Honny people have the word Chlef in their job title? (This is pretty tricky V Buss there a correlation betwee length of the Job Title string and Salary year? (2011-2014) BRANI Data Science Technologies (Data Engineering: Numpx and Pandas) Assignment #3 Due Date: 28-04-2021 Task 1 Ecommerce Purchases In this Exercise you will be given some Fake Data about some purchases done through Amazon! Feel free to reference the solutions. Most of the tasks can be solved in different ways. For the most part, the questions get progressively harder Please excuse anything that doesn't make "Real-World" sense in the dataframe all the data is fake and made up Also note that all of these questions can be answered with one line of code 1 Import pandas and read in the Ecommerce Purchases csv file and set it to a DataFrame called esom. II. Check the head of the DataFrame. III How many rows and columns are there? IV What is the average Purchase Price? V What were the highest and lowest purchase prices? VI How many people have English 'en' as their Language of choice on the website? VII How many people have the job title of "Lawyer" 2 VIII How many people made the purchase during the AM and how many people made the purchase during PM 2 (Hint: Check out value countso) X What are the 5 most common Job Titles? XI Someone made a purchase that came from Lot: "90 WT", what was the Purchase Price for this XII What is the email of the person with the following Credit Card Number: 4926535242672853 XIT How many people have American Express as their Credit Card Provider and made a purchase above $952 Hard: How many people have a credit card that expires in 2025? Hard: What are the top 5 most popular email providers/hosts (exgmail.com, yahoo.com, etc...) IX wvwmm xm wwww transaction? XIV XV (Data Engineering: Numpy and Pandas) Assignment #3 Due Date: 28-04-2021 Task 1 Ecommerce Purchases In this Exercise you will be given some Fake Data about some purchases done through Amazonl Feel free to reference the solutions. Most of the tasks can be solved in different ways. For the most part, the questions get progressively harder Please excuse anything that doesn't make "Real-World" sense in the dataframe, all the data is fake and made up Also note that all of these questions can be answered with one line of code I. esom II III IV V VI VII VIII Import pandas and read in the Ecommerce Purchases csv file and set it to a DataFrame called Check the head of the DataFrame. How many rows and columns are there? What is the average Purchase Price? What were the highest and lowest purchase prices? How many people have English 'en' as their Language of choice on the website? How many people have the job title of "Lawyer"? How many people made the purchase during the AM and how many people made the purchase during PM (Hint: Check out value..count) What are the 5 most common Job Titles? Someone made a purchase that came from Lot: "90 WT" what was the Purchase Price for this transaction? What is the email of the person with the following Credit Card Number: 4926535242622953 How many people have American Express as their Credit Card Provider and made a purchase above $952 Hard: How many people have a credit card that expires in 2025? Hard: What are the top 5 most popular email providers/hosts (@g_gmail.com, yahoo.com, etc...) IX X XI XII XIII XIV XV Task 2: SF Salaries I II IV. V. Welcome to a quick exercise for you to practice your pandas skills! We will be using the SF Salaries Dataset from Kaggle! Just follow along and complete the tasks outlined in bold below. The tasks will get harder and harder as you go along, Import pandas as pd. Read Salaries.csv as a dataframe called sal. Check the head of the DataFrame. III Use the info() method to find out how many entries there are. What is the average BasePay ? What is the highest amount of OvertimePay in the dataset. 2 VI What is the job title of JOSEPH DRISCOLL 2 Note: Use all caps, otherwise you may get an answer that doesn't match up (there is also a lowercase Joseph Driscoll). VII How much does JOSEPH DRISCOLL make (including benefits)? What is the name of highest paid person (including benefits)? What is the name of lowest paid person (including benefits)? Do you notice something strange about how much he or she is paid? What was the average (mean) BasePax of all employees per year? (2011-2014)_2 XI How many unique job titles are there? What are the top 5 most common jobs? XIII How many Job Titles were represented by only one person in 2013? (eg. Job Titles with only one occurrence in 2013?) How many people have the word Chief in their job title? (This is pretty tricky) XV Bonus: Is there a correlation between length of the Job Title string and Salary? VIII IX X XII XIV
