Import csv file and create chart

Specific domains Data handling
1

I want to import a csv file and plot some of the column data. Is there a example how to do this. I could do it with the older import tool but uiimport is not the same as the older uiSpreadsheet.

2

what about csvRead and plot ?

1 Like
3

I reinstalled version 6.1.1 to see how uiSpreadsheet and uiimport differ. I see there are no options to convert in uiimport; in my case, I converted to double in uiSpreadsheet.

Here is the function generated by uiSpreadsheet. This creates a variable containing values of type double.

clear importdata; 
 
function [data] = importdata(filename) 
    data = csvRead(filename, ";", ",", "double"); 
endfunction 
 
[data] = importdata("F:\2857-0570_Rog\20250212_144220_log.csv"); `

Here is the function generated by uiimport. This creates a variable containing a table which cannot be plotted without further processing.

clear import_20250212_144220_log;

function [data] = import_20250212_144220_log(filename)
    opts = detectImportOptions(filename, "Delimiter", ";", "Decimal", ",");
    data = readtable(filename, opts, "VariableNames", ["Date","Time","L1 Current / A","L2 Current / A","L3 Current / A","L1 Voltage / V","L2 Voltage / V","L3 Voltage / V","L1 Active Power / W","L2 Active Power / W","L3 Active Power / W"]);
    data.Date.format = "dd.MM.yy";
    data.Time.format = "hh:mm:ss";
endfunction

data = import_20250212_144220_log("F:\2857-0570_Rog\20250212_144220_log.csv");

Is there any tool similar to uiSpreadsheet in later versions of scilab?