Use the data file “marketing_campaign.csv” for this problem. Note: There are rows at the top of the file that must be skipped. a. Read the data into R and create a subset consisting of the following columns: Education, Marital_Status, Income, Dt_Customer, MntFruits, and Complain. b. Convert the data a type of the following columns: Education Ordered factor (Hint: Level of “2n Cycle” is between Graduation and Master Marital_Status Unordered factor Income Double precision numeric Complain Logical c. Convert the data type of Dt_Customer to Date. d. With proper code check the data types of columns are as stated in (b) and (c).

Use the data file “marketing_campaign.csv” for this problem. Note: There are rows at the top of the file that must be skipped. a. Read the data into R and create a subset consisting of the following columns: Education, Marital_Status, Income, Dt_Customer, MntFruits, and Complain. b. Convert the data a type of the following columns: Education Ordered factor (Hint: Level of “2n Cycle” is between Graduation and Master Marital_Status Unordered factor Income Double precision numeric Complain Logical c. Convert the data type of Dt_Customer to Date. d. With proper code check the data types of columns are as stated in (b) and (c).

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts

Section: Chapter Questions

Problem 11RA

See similar textbooks

Similar questions

dataframe = pd.read_csv('https://raw.githubusercontent.com/Explore-AI/Public-Data/master/Data/regression_sprint/titanic_train_raw.csv') df = pd.read_csv('https://raw.githubusercontent.com/Explore-AI/Public-Data/master/Data/regression_sprint/titanic_test_raw.csv') Write a function that takes in as input a dataframe and a column name, and returns the mean for numerical columns and the mode for non-numerical columns. Function Specifications: The function should take two inputs: (df, column_name), where df is a pandas DataFrame, column_name is a str. If the column_name does not exist in df, raise a ValueError. Should return as output the mean if the specified column is numerical and return a list of the mode(s) otherwise. The mean should be rounded to 2 decimal places. If there is more than one mode for a given non-numerical column, the fuction should return a list of all modes. def calc_mean_mode(df, column_name): # your code here return calc_mean_mode(df,'Age') Expected Outputs:…
Exercise 6 (Operations on DataFrame) Step a: Create two dataframes df1 and df2 as follows:import numpy as npimport pandas as pdrng = np.random.RandomState(100)df1 = pd.DataFrame(rng.randint(0, 100, (4, 3)), columns=['A', 'B', 'C'])df2 = pd.DataFrame(rng.randint(0, 100, (3, 4)), columns=['A', 'B', 'C', 'D']) Step b: Create a new dataframe df which is the summation of df1 and df2; Step c: Subtract all columns of df by the half of column 'C' in df1; (Remark: the values in df should be updated) Step d: Replace the NaN in df by 10; (Remark: the values in df should be updated) Step e: Use df.apply() to calculate the summation of the numbers in each row of df, and show the result. (Remark: the result should be a vector of four values)
Let the document be “good bad student good bad instructor” and the query be “good student”. Fill out the empty columns in the following table and then compute the cosine similarity between the document vector and the query vector. In the table, df denotes document frequency, idf denotes inverse document frequency (i.e., idft = log10N/dft), tf denotes term frequency, log tf denotes the tf weight based on log-frequency weighting as shown in slides (i.e., 1+log10tft,d for tft,d> 0 and 0 otherwise), d is the document vector, d’ is the length-normalized d, q is the query vector, and q’ is the length-normalized q. Assume N (number of documents in the corpus) = 10,000,000.
1)Consider the following DTD. All unspecified elements are #PCDATA.<!DOCTYPE bibliography [<!ELEMENT book (title,author+,year,publisher,place?)><!ELEMENT article (title,author+,journal,year,number,volume,pages?)><!ELEMENT author (last_name, first_name)>...]>Write the following queries in XQuery. Assume Last names of authors are unique.(a) List all books authored by Ullman.(b) List articles published in Vol. 32 No. 2 of ACM Transactions on Database Systems.(c) List journals that published an article on XML in 2001 (that is, “XML” appears in the title of thearticle).(d) List authors that have published a book in 2001 and another book in 2003.(e) List publishers, and for each publisher list the books they have published as subelements. Chooseappropriate tags for your output.(f) List every author, and for each author list the number of articles he/she published in 2001. Chooseappropriate tags for your output.
1)Consider the following DTD. All unspecified elements are #PCDATA.<!DOCTYPE bibliography [<!ELEMENT book (title,author+,year,publisher,place?)><!ELEMENT article (title,author+,journal,year,number,volume,pages?)><!ELEMENT author (last_name, first_name)>...]>Write the following queries in XQuery. Assume Last names of authors are unique.(a) List all books authored by Ullman.(b) List articles published in Vol. 32 No. 2 of ACM Transactions on Database Systems.(c) List journals that published an article on XML in 2001 (that is, “XML” appears in the title of thearticle).(d) List authors that have published a book in 2001 and another book in 2003.(e) List publishers, and for each publisher list the books they have published as subelements. Chooseappropriate tags for your output.(f) List every author, and for each author list the number of articles he/she published in 2001. Chooseappropriate tags for your output. answer d,e,f questions
(b) Using IF function, write a formula in cell range D24 to display your recommendation. Hint: IF the Weighted Score of VDI is more than DaaS, then VDI should be recommended, else DaaS should be recommended. (g) Using INDEX Function, write a formula in cell range D68 to display the vendor. Hint: INDEX the value of cell D67 in the array D55:F55. Screenshots attached thnaks
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]:
Use the sacramento.csv file to complete the following assignment. Create a file, sacramento.py, that loads the .csv file and runs a logistic regression. The regression should predict whether or not a house has 1 or more than one bathroom based on beds, sqft, and price, in that order. Note: you will not need to upload the .csv to CodeGrade because I have pre-loaded it. You will need to create a new variable from baths, and it should make it such that those observations of 1 bath correspond to a value of 0, and those with more than 1 bath correspond to a 1. Make sure to add a constant using sm.add_constant(X) Your file should print the results in this way: print(mod.params.round(2)) print(mod.pvalues.round(2)) print('The smallest p-value is for sqft')
Polynomial regression is a form of nonlinear regression that describes nonlinear relationships in a dataset. There are several advantages to linear regression, mainly high accuracy. For your assignment, you will build a polynomial regression model in Python. The data is in a .CSV file that has the following information types. Position Level Salary Business Analyst 1 45000 Junior Consultant 2 50000 Senior Consultant 3 60000 Manager 4 80000 Country Manager 5 110000 Region Manager 6 150000 Partner 7 200000 Senior Partner 8 300000 C-level 9 500000 CEO 10 1000000 Using this data, our model should be able to predict the value of an employee candidate given their years of experience. The Python file must demonstrate the prediction of employee salary based on years of experience.
Using R programming: Create a function that randomly picks up two columns from a data frame and does the following: if both columns are of character values, test if they are independent; if both columns are numeric, create a data plot to show their relationship trends with a regression line attached; if one is numeric and the other character, test if the numeric column is related to the character column
I need help with Use the sacramento.csv file to complete the following assignment. Create a file, sacramento.py, that loads the .csv file and runs a logistic regression. The regression should predict whether or not a house has 1 or more than one bathroom based on beds, sqft, and price, in that order. Note: you will not need to upload the .csv to CodeGrade because I have pre-loaded it. You will need to create a new variable from baths, and it should make it such that those observations of 1 bath correspond to a value of 0, and those with more than 1 bath correspond to a 1. Make sure to add a constant using sm.add_constant(X) Your file should print the results in this way: print(mod.params.round(2)) print(mod.pvalues.round(2)) print('The smallest p-value is for sqft')
Use import sys. Use the german_credit_data.csv file to complete the following assignment. Create a file, german.py, that loads the .csv file and runs a regression predicting credit amount from age and duration, in that order. Add a constant using sm.add_constant(data). You will need to rename the column 'Credit amount' and should change it to 'Credit_amount'. Note: you will not need to upload the .csv to CodeGrade because I have pre-loaded it. Then, print the parameters and R-squared to 2 decimals using print(model.params.round(2)) print(model.rsquared.round(2))