70.2K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer