Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Download the following files into your computer: - sales.csv - load sales.mlx Upload them to a folder into MATLAB online. Execute the script load_sales.mlx so

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Download the following files into your computer: - sales.csv - load sales.mlx Upload them to a folder into MATLAB online. Execute the script load_sales.mlx so that the file sales.csv is loaded into MATLAB. Fill the gaps in below. Note that the answers are case sensitive. 1. The file sales.csv has been loaded into a variable with name 2. In the imported data, the type of the column Employee is 3. The imported table has rows. 4. To change the type of column Payment_Type to categorical, you must write this MATLAB code: = Import data from text file Script for importing data from the following text file: filename: /MATLAB Drive/FOSE1025 Week 8/Qui Auto-generated by MATLAB on 28-Apr-2021 18:09:43 Set up the Import Options and import the data opts = delimitedTextImportoptions("NumVariab \% Specify range and delimiter opts. DataLines =[2, Inf ]; opts. Delimiter =","; \% Specify column names and types opts. VariableNames = ["Order_ID", "Order_Dat load_sales.mlx + 8 opts. VariableNames = ["Order_ID", "Order_Dat opts. VariableTypes =[ "double", "datetime", \% Specify file level properties opts. ExtraColumnsRule = "ignore"; opts. EmptyLineRule = "read"; \% Specify variable properties opts = setvaropts (opts, ["Category", "Paymen opts = setvaropts (opts, ["Employee", "Catego opts = setvaropts (opts, "Order_Date", "Input opts = setvaropts(opts, "Sales", "TrimNonNum opts = setvaropts(opts, "Sales", "Thousandss \% Import the data the_sales = readtable("sales.csy", Clear temporary variables 24 clear opts Command Window Download the following files into your computer: - sales.csv - load sales.mlx Upload them to a folder into MATLAB online. Execute the script load_sales.mlx so that the file sales.csv is loaded into MATLAB. Fill the gaps in below. Note that the answers are case sensitive. 1. The file sales.csv has been loaded into a variable with name 2. In the imported data, the type of the column Employee is 3. The imported table has rows. 4. To change the type of column Payment_Type to categorical, you must write this MATLAB code: = Import data from text file Script for importing data from the following text file: filename: /MATLAB Drive/FOSE1025 Week 8/Qui Auto-generated by MATLAB on 28-Apr-2021 18:09:43 Set up the Import Options and import the data opts = delimitedTextImportoptions("NumVariab \% Specify range and delimiter opts. DataLines =[2, Inf ]; opts. Delimiter =","; \% Specify column names and types opts. VariableNames = ["Order_ID", "Order_Dat load_sales.mlx + 8 opts. VariableNames = ["Order_ID", "Order_Dat opts. VariableTypes =[ "double", "datetime", \% Specify file level properties opts. ExtraColumnsRule = "ignore"; opts. EmptyLineRule = "read"; \% Specify variable properties opts = setvaropts (opts, ["Category", "Paymen opts = setvaropts (opts, ["Employee", "Catego opts = setvaropts (opts, "Order_Date", "Input opts = setvaropts(opts, "Sales", "TrimNonNum opts = setvaropts(opts, "Sales", "Thousandss \% Import the data the_sales = readtable("sales.csy", Clear temporary variables 24 clear opts Command Window

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Loren A Nikolai, D. Bazley and Jefferson P. Jones

10th Edition

978-0324300987

Students also viewed these Accounting questions