MATLAB: Access .txt and .csv, edit data, error statistics

csvedit datatxt

Hi guys!

I would appreciate your help on the following:

I have several files (attached you can find two of them) that contain measured (.txt) and simulated (.csv) hourly values for some meteorological variables. I am only interested in temperature and relative humidity. The simulated period run from 01-Jul-2019 to 30-Sep-2019, while for the observations, I have a couple of months more.

What I need to do is open both files for every station (here I attached only "Airport"), access the dates that both files contain data and produce graphs and error metrics.

Any ideas please?

Best Answer

A basic method for importing only the Temp and RH data into tables

filename = 'Airport.csv';
opts = detectImportOptions(filename);
opts.SelectedVariableNames = opts.SelectedVariableNames(16:17); % Columns 16 and 17 from .csv are temp and RH
data1 = readtable(filename,opts);
filename = 'Hourly Data Airport 2019.txt';
opts = detectImportOptions(filename);
opts.SelectedVariableNames = opts.SelectedVariableNames(2:3); % Columns 2 and 3 from .csv are temp and RH
data2 = readtable(filename,opts);

Related Solutions

MATLAB: How to create filename with variable within loop

How about the following?

T = readtable('Stations coordinates.txt');
fileName = append('Hourly Data ',T.Station,' 2015.txt');

>> fileName

fileName =

16×1 cell array

{'Hourly Data Airport 2015.txt' }

{'Hourly Data Eptapurgio 2015.txt' }

{'Hourly Data Martiou 2015.txt' }

{'Hourly Data Lagada 2015.txt' }

{'Hourly Data Malakopi 2015.txt' }

{'Hourly Data Egnatia 2015.txt' }

{'Hourly Data Dimarxeio 2015.txt' }

{'Hourly Data Pedio Arews 2015.txt' }

{'Hourly Data Paparrigopoulou 2015.txt' }

{'Hourly Data Parko 2015.txt' }

{'Hourly Data Taratsa 2015.txt' }

{'Hourly Data Taratsa Babzelis 2015.txt'}

{'Hourly Data Taratsa Zanis 2015.txt' }

{'Hourly Data Kalamaria 2015.txt' }

{'Hourly Data Panorama 2015.txt' }

{'Hourly Data Kordelio 2015.txt' }

MATLAB: Importing CSV – Selecting Specific Variables or Ignoring Variables

You can refer to the following code snippet to resolve your problem:

% read an inbuilt spreadsheet
opts = detectImportOptions('airlinesmall_subset.xlsx');
preview('airlinesmall_subset.xlsx',opts)
opts.Sheet = '2007';
% define the variable indices which you want to read
% 2:2:10 ensures that we read alternate columns from the sheet
% Modify the indices as per your requirement
varIndex = [1, 2:2:10] 
opts.SelectedVariableNames = varIndex
% Observe selected variables
opts.SelectedVariableNames 
opts.DataRange = '2:11';
M = readmatrix('airlinesmall_subset.xlsx',opts)

Best Answer

Related Solutions

MATLAB: How to create filename with variable within loop

MATLAB: Importing CSV – Selecting Specific Variables or Ignoring Variables

Related Question