Scatter 3 xlsx plot with an irrigular range of dates

1 次查看（过去 30 天）
Silver
Silver 2018-9-11
评论： Silver 2018-10-28
Hello ! I want to scatter an csv file with a colorbar (plot 3 parameters). Fro this purpose I ued this program :
figure
date=txt(:,1)
Q=date(2:end)
scatter(Q(:,1),num(:,1),12,num(:,16)),colorbar;
set(gca,'xticklabel',raw(1:length(raw),1))
set(gca,'yticklabel',raw(1:length(raw),2))
xlabel('Date');
ylabel('Latitude');
title ('Temp38');
what does'nt work with an error messg "Error using scatter (line 56) Input arguments must be numeric, datetime, duration or categorical." Because the format of the date is like :
  • 2016.03.01 14:39:00
  • The step of the date is one minute, but at some level , the date changes literally like from 2016.03.01 17:40:00 to 2016.03.15 16:43:00 (this is due to an assembly of several files but it does not make problem if there is a possibility to make a regular step)
Here is a photo to show the type of data I have (the rest of the data are numeric) :
And you can find attached the file I want to plot. Any Ideas? I will appreciate your help !

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

采纳的回答

KSSV
KSSV 2018-9-11
T = readtable('1.xls') ;
x = T.(3) ; % longitude
y = T.(2) ; % latitude
c = T.(4) ;
scatter(x,y,10,c,'filled')
Follow the same with other variables.
  4 个评论
显示 2更早的评论
Silver
Silver 2018-9-11
编辑：Silver 2018-9-11
I've already used this code wich gave me the same value of conevrsion for all dates :/ , it does not solve the problem yet
date=txt(:,1) %dates are in the first column
x=date(2:end) % plot dates beginning from the second cell
time=datenum(x)
scatter(time,num(:,1),12,num(:,10)),colorbar;
datetick('x','yy/mm/dd HH:MM:SS','keeplimits','keepticks')
Silver
Silver 2018-10-28
Hey am back again x) ! I want to change the column names of the table , but when I use this code :
T.Properties.VariableNames = {'Date_Time' 'Latitude' 'Longitude' 'Course' 'Speed' 'Temp_SBE45' 'Cond_SBE45' 'SoundVel_SBE45' 'full' 'pH_SeaFET' 'Saturation' 'Salinity_SBE45' 'Temperature_Optode' 'flow_pCO2' 'pH_Meinsberg' 'Temp_in_SBE38' 'Temp_Meinsberg' 'Oxygen' 'pCO2' 'pressure' 'flow_in' 'flow_main' 'flow_pH' 'Turbidity' 'halffull' 'Chl_a' 'Variance' 'pH_Meinsberg' 'Variance' 'Temp_Meinsberg' 'Variance' 'pH_SeaFET' 'Variance' 'pCO2' 'Variance' 'pressure' 'Variance' 'flow_in' 'Variance' 'flow_main' 'Variance' 'flow_pH' 'Variance' 'flow_pCO2' 'Variance' 'halffull' 'Variance' 'full' 'Variance'}
I always get this error message, I dont understand where the problem lies, I even change the variable name but in vain :
Duplicate variable name: 'Temperature_Optode'.
Do you have any ideas ?

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Categorical Arrays 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by