MATLAB: Data import from excel (csv)

data importMATLAB

Hi i import data from csv by using readtable command

T = readtable('Report.csv','HeaderLines',8);

the data comes in this form

how can i seperate datetime in one column and reading in other seperate columns. i would be so grateful if someone could help me out in this

Thanks

Best Answer

This is perhaps a bit more complicated than it might be, however readtable does not import it properly, so other approaches are necessary:

[D,S] = xlsread('example.csv');
dtts = table(datetime(S(2:end,1), 'InputFormat', 'dd-MM-yy hh:mm:ss a ''GMT''', 'TimeZone', 'UTC'),'VariableNames',S(1,1));
dt = array2table(D, 'VariableNames',S(1,2:end));
T1 = [dtts,dt];
T1_Sample = T1(1:5,:)                                       % Delete Later

producing:

T1_Sample =
  5×8 table
         timestamp          MWS_TOTAL    NEB_RWP1_Ladies_Flow_Meter    NEB_CWS_METER    NEB2_CWS_GENTS_FLOW    NEB_CWS_LADIES_FLOW    NEB_HWS_LADIES_FLOW    NEB_MWS_1ST CANTEEN
    ____________________    _________    __________________________    _____________    ___________________    ___________________    ___________________    ___________________
    20-Nov-2018 10:00:00      15063              1.0076e+06                12350               27269                  6.58                   36.56               4.8806e+05     
    20-Nov-2018 12:00:00      15067              1.0079e+06                12354               27274                  6.58                   36.56                4.881e+05     
    20-Nov-2018 12:15:00      15068               1.008e+06                12355               27277                  6.58                   36.56               4.8813e+05     
    20-Nov-2018 12:30:00      15069               1.008e+06                12356               27277                  6.58                   36.56               4.8813e+05     
    20-Nov-2018 12:45:00      15070              1.0081e+06                12356               27279                  6.58                   36.56               4.8814e+05

Experiment to get the result you want.

Related Solutions

MATLAB: How to calculate the hourly average

If you have R2016b or later, this is straightforward:

T1 = readtable('Matlab.csv');
First_5_Rows = T1(1:5,:);
TT1 = table2timetable(T1);
TT1 = retime(TT1, 'hourly','mean');
First_10_Rows = TT1(1:10,:)

producing:

First_10_Rows =
  10×3 timetable
           Var1             Var2       Var3      Var4 
    ___________________    _______    ______    ______
    06/23/2015 01:00:00    -30.195    71.304    159.62
    06/23/2015 02:00:00    -30.239    71.288    159.57
    06/23/2015 03:00:00     -29.93     71.46    158.83
    06/23/2015 04:00:00    -29.922    71.487    157.72
    06/23/2015 05:00:00     -29.35    71.939    155.11
    06/23/2015 06:00:00    -28.742    72.334    156.36
    06/23/2015 07:00:00    -28.336    72.619    158.46
    06/23/2015 08:00:00    -28.339    72.436    158.91
    06/23/2015 09:00:00    -27.784    72.907    157.82
    06/23/2015 10:00:00    -27.128    73.226    153.73

MATLAB: Finding the dominant frequency via fourier transform

Your data is sampled with Fs=10 Hz, Your Frequency spectrum is :

 Fs=10;
 N=length(x);
 fx=fft(x)/N;
 f=(0:N-1)*Fs/N;
 figure, plot(f(1:end/2),10*log10(abs(fx(1:end/2))))

Best Answer

Related Solutions

MATLAB: How to calculate the hourly average

MATLAB: Finding the dominant frequency via fourier transform

Related Question