How to read tabular data from *.DAT files into MATLAB?

Dear all,

just tried to read a *.dat file into MATLAB. Loading the file worked out quite fine.

A=importdata('PIOMAS.vol.daily.1979.2013.Current.v2.dat');
A.data;

However, the resulting data looks strange (binary issue?).

2.0130    0.1490    0.0193
2.0130    0.1500    0.0192
2.0130    0.1510    0.0191

How it should look like

Year  #day  Vol
1979  1  26.405
1979  2  26.496
1979  3  26.582
1979  4  26.672
1979  5  26.770
1979  6  26.867
1979  7  26.940
1979  8  27.013
1979  9  27.095
1979  10  27.185

Maybe somebody knows how to do the trick. Best regards, Fernandes

[ebot joel]

M=dlmread('filename.extension')

plot(M(:,1.),M(:,2))

[Luis Miguel Ariza Morales]

clear; close all; clc;

A=importdata('nombre_documento.extension');

A.data;

% para ver la primera columna

A.data(:,1); % muestra números en pantalla

% para ver más de una columna

M=[A.data(:,2) A.data(:,3)];

% para graficar lo que deseo:

plot(M(1,1),M(1,2),'.b');

hold on

for i=1:size(M,1)

axis([0 1 0 2]) % en x[0 1]; en y [0 2]

grid on

plot(M(i,1),M(i,2),'.b')

end

Answer 1

[Walter Roberson]

You can use the “Import Tool” app or the “readtable” function to accomplish this.

Right click on the CSV file and select the “Import Tool”, which will help you through the import process. The Import Tool helps you import the data interactively.

Or use the “readtable” function which imports the data as a table:

T = readtable('myCSVfile.csv');

For more information on using “Import Tool” see:

https://www.mathworks.com/help/matlab/import_export/import-data-interactively.html

For more information on using “readtable” see:

https://www.mathworks.com/help/matlab/import_export/import-mixed-text-and-numeric-data-from-a-text-file.html

[G]

Thank you very much for the fast reply and the proper solution.

[Chandra Sekhar Uppu]

collect is showing error as unknown option

[Walter Roberson]

'CollectOutput'

[Akshay Kumar]

You can change '1' to '0' in case your first line/character is not read.

[gagandeep singh]

still i can not got my answer or give error when set to 0.kindly do needful.

[Walter Roberson]

gagandeep singh please attach a sample of your input file, and your code.

[janani subraveti]

Hi, I need to import a dat file into matlab and my dat file consists of hex data ... how can i do it? I need my imported data to be present as hex data only not as decimal

[Walter Roberson]

janani subraveti is the file the text representation of hex data, or is it binary numeric data that you need to represent as hex ?

If it is text representation of hex data, then you might be able to read it as strings.

An extract from the file would help organize our thinking.

[janani subraveti]

my file is in binary numeric data and inorder to open that file I have to open it with the help of Hex editor tools and i need to import that data into workspace so that i do buffer operation over it and my commands for reading that data are like this but I am facing trouble when i use 'from workspace' block in simulink to get the data from B

fileID = fopen('pet_data.dat');
Onebyte = fread(fileID,'*ubit8');
B=dec2hex(Onebyte);

[Image Analyst]

Start your own question, and attach your data file. Read this first though: http://www.mathworks.com/matlabcentral/answers/6200-tutorial-how-to-ask-a-question-on-answers-and-get-a-fast-answer

[Walter Roberson]

dec2hex() creates character vectors. Simulink signals cannot be characters.

You could

B = double( dec2hex(Onebyte) );

and use that, but for most purposes it is easier to just transfer the byte stream Onebyte . If you had a need to output the bytes in hex format to a serial port you could use https://www.mathworks.com/matlabcentral/fileexchange/5060-rs232-blockset

[janani subraveti]

I could load data from the workspace and could send it to buffer using 'from workspace' block in simulink but instead of that i want to use 'from file' block and for using that i need to store my data into .mat file, how can I do it? and my code is in this way when i used 'from workspace' block when my data is being loaded into my workspace.In the following case, I want to give C to a mat file and use the block 'from file' and load C from it, how can I do that?

clc;
Fs=1000;
Ts=1/Fs;
fileID = fopen('pet_data.dat'); 
OneByte = fread(fileID,'*ubit8');
A=double(OneByte);
B=[0:Ts:(length(A)-1)/Fs]';
C=[B A];
D=dec2hex(A);

[Walter Roberson]

ts = timeseries(B, A);
save('pet_ts.mat', 'ts', '-v7.3');

Now From File of pet_ts