How to convert csv to Heatmap?

Question

Stride Okorie 2022-7-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1768235-how-to-convert-csv-to-heatmap

回答： Vandit 2023-9-1

Hello, I am relatively new to using MATLAB so I am coming across some issues. I want to convert a .csv file with A LOT of raw data and visualize it as a heatmap. It is a 36189x88 data table. This code I have so far shows something but it is not really giving me what I want. Any help or advice would be greatly appreciated.

clc;
clear 
close all;
data = readtable("N303_M.2.csv");
%% Data Filtering/Processing
clc, clearvars -except data, format compact, close all
%convert from Table to Array
strain(:, 1:88) = table2array(data(:,1:88));
%% Data Visualizations
figure(1);
plot(strain(:, 1:88));
heatmap(strain(:, 1:88),'Colormap', jet,)
title('Visual Data for Mat')

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

dpb 2022-7-26

Well, we're at a loss to help -- no data, not even a figure or a hint of what you might think it is you would want instead...

What would 32K x 88 data values be, even, pray tell? You've taken all of it and just mushed it together as one thing, surely there's some demarcation of what the 88 columns would be?

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Vandit 2023-9-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1768235-how-to-convert-csv-to-heatmap#answer_1299296

在 MATLAB Online 中打开

Hi,

To visualize your large dataset as a heatmap, you can make some modifications to your existing code. Here's an updated version:

clc;
clear 
close all;
data = readmatrix('N303_M.2.csv');
%% Data Filtering/Processing
clc, clearvars -except data, format compact, close all
% Data Normalization
normalizedData = (data - min(data(:))) / (max(data(:)) - min(data(:)));
% Create the heatmap
figure;
heatmap(normalizedData, 'Colormap', jet);
colorbar;
title('Visual Data for Mat');

The provided code reads data from a CSV file named "N303_M.2.csv" using 'readmatrix' function and stores it in the variable 'data'. Next, a new figure window is created, and the normalized data is used to generate a heatmap using the 'heatmap' function. The colormap is set to 'jet', which determines the color scheme of the heatmap.

To know more about 'readmatrix' and 'heatmap' function, refer to the link below:

Read matrix from file - MATLAB readmatrix (mathworks.com)

Create heatmap chart - MATLAB heatmap (mathworks.com)

Hope this helps.

Thankyou