In this assignment, you will practice using Alteryx to create a workflow to prepare loan data for analysis.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

In this assignment, you will practice using Alteryx to create a workflow to prepare loan data for analysis.

Instructions

1. (1 point) Create a step to read in the loan_application.csv file.

2. (2 points) Convert the data types of the following columns to the data type listed after the hyphen:

o Columns starting with “CNT” – INT32

o Columns starting with “AMT” – Float

3. (1 point) Remove rows with NAs or NULL in the AMT_INCOME_TOTAL

4. (1 point) Filter data to keep only the rows where AMT_CREDIT is at least 300,000

5. (2 points) Join this data with credit_bureau dataset (read it first) using the common field “SK_ID_CURR”

6. (2 points) Keep only the following columns from the joint dataset: SK_ID_CURR, TARGET, AMT_INCOME_TOTAL, and AMT_CREDIT_SUM. Make sure you set their data types correctly. Also remove any duplicate observations from this dataset, using the unique tool.

7. (1 point) Finally, create a step to save the datafile to your desktop as netid_HW4_data.csv. For example, if your email address is jdoe@illinois.edu, then save the data as jdoe_HW4_data.csv.

Submission*

1. You are given two data files: credit_bureau.csv and loan_application.csv.

2. Use Alteryx to complete the required ETL steps.

3. Save your Alteryx workflow file (.yxmd format) as netid_HW4.yxmd

4. Compress the jdoe_HW4.yxmd file as a .zip or .rar file.

5. Submit the .zip or .rar file on Compass2g before the deadline.

Attachments:

Expert's Answer

1117 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme