Question: 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

 Download the following files into your computer: - sales.csv - loadsales.mlx Upload them to a folder into MATLAB online. Execute the scriptload_sales.mlx so that the file sales.csv is loaded into MATLAB. Fill thegaps in below. Note that the answers are case sensitive. 1. The

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!