Histogram from a table data / or convert table data into numeric
117 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hi,
I have a table of 1000*2 values,
and i am trying to make a histogram,
but its giving me error
Error using histogram
Expected input number 1, x, to be one of these types:
double, single, uint8, uint16, uint32, uint64, int8, int16, int32, int64, logical, datetime, duration, categorical
Instead its type was table.
0 0.957766000000000
0.00100000000000000 6.00000000000000e-06
0.00200000000000000 1.00000000000000e-06
0.00300000000000000 9.00000000000000e-06
0.00400000000000000 9.00000000000000e-06
0.00500000000000000 1.00000000000000e-05
0.00600000000000000 1.00000000000000e-05
0.00700000000000000 8.00000000000000e-06
0.00800000000000000 4.00000000000000e-06
0.00900000000000000 1.30000000000000e-05
0.0100000000000000 8.00000000000000e-06
0.0110000000000000 9.00000000000000e-06
0.0120000000000000 3.00000000000000e-06
0.0130000000000000 1.00000000000000e-05
0.0140000000000000 1.40000000000000e-05
0.0150000000000000 4.00000000000000e-06
0.0160000000000000 1.00000000000000e-05
0.0170000000000000 6.00000000000000e-06
0.0180000000000000 6.00000000000000e-06
0.0190000000000000 9.00000000000000e-06
0.0200000000000000 1.50000000000000e-05
0.0210000000000000 1.00000000000000e-05
0.0220000000000000 1.50000000000000e-05
0.0230000000000000 1.50000000000000e-05
0.0240000000000000 6.00000000000000e-06
0.0250000000000000 1.20000000000000e-05
0.0260000000000000 5.00000000000000e-06
0.0270000000000000 8.00000000000000e-06
0.0280000000000000 5.00000000000000e-06
0.0290000000000000 8.00000000000000e-06
0.0300000000000000 7.00000000000000e-06
0.0310000000000000 7.00000000000000e-06
0.0320000000000000 8.00000000000000e-06
0.0330000000000000 8.00000000000000e-06
0.0340000000000000 6.00000000000000e-06
0.0350000000000000 7.00000000000000e-06
0.0360000000000000 1.20000000000000e-05
0.0370000000000000 1.00000000000000e-05
0.0380000000000000 8.00000000000000e-06
0.0390000000000000 1.10000000000000e-05
0.0400000000000000 1.10000000000000e-05
0.0410000000000000 9.00000000000000e-06
0.0420000000000000 9.00000000000000e-06
0.0430000000000000 7.00000000000000e-06
0.0440000000000000 1.30000000000000e-05
0.0450000000000000 1.40000000000000e-05
0.0460000000000000 1.10000000000000e-05
0.0470000000000000 6.00000000000000e-06
0.0480000000000000 7.00000000000000e-06
0.0490000000000000 8.00000000000000e-06
0.0500000000000000 9.00000000000000e-06
0.0510000000000000 1.00000000000000e-05
0.0520000000000000 1.10000000000000e-05
0.0530000000000000 8.00000000000000e-06
0.0540000000000000 8.00000000000000e-06
0.0550000000000000 4.00000000000000e-06
0.0560000000000000 1.00000000000000e-05
0.0570000000000000 1.30000000000000e-05
0.0580000000000000 1.00000000000000e-05
0.0590000000000000 1.30000000000000e-05
0.0600000000000000 5.00000000000000e-06
0.0610000000000000 4.00000000000000e-06
0.0620000000000000 7.00000000000000e-06
0.0630000000000000 6.00000000000000e-06
0.0640000000000000 9.00000000000000e-06
0.0650000000000000 1.00000000000000e-05
0.0660000000000000 1.00000000000000e-05
0.0670000000000000 1.10000000000000e-05
0.0680000000000000 1.30000000000000e-05
0.0690000000000000 1.20000000000000e-05
0.0700000000000000 1.00000000000000e-05
0.0710000000000000 1.10000000000000e-05
0.0720000000000000 1.00000000000000e-05
0.0730000000000000 1.40000000000000e-05
0.0740000000000000 1.10000000000000e-05
0.0750000000000000 1.00000000000000e-05
0.0760000000000000 1.00000000000000e-05
0.0770000000000000 2.00000000000000e-05
0.0780000000000000 9.00000000000000e-06
0.0790000000000000 9.00000000000000e-06
0.0800000000000000 6.00000000000000e-06
0.0810000000000000 1.10000000000000e-05
0.0820000000000000 9.00000000000000e-06
0.0830000000000000 9.00000000000000e-06
0.0840000000000000 9.00000000000000e-06
0.0850000000000000 1.10000000000000e-05
0.0860000000000000 1.10000000000000e-05
0.0870000000000000 6.00000000000000e-06
0.0880000000000000 1.70000000000000e-05
0.0890000000000000 1.30000000000000e-05
0.0900000000000000 1.20000000000000e-05
0.0910000000000000 7.00000000000000e-06
0.0920000000000000 1.30000000000000e-05
0.0930000000000000 1.90000000000000e-05
0.0940000000000000 7.00000000000000e-06
0.0950000000000000 8.00000000000000e-06
0.0960000000000000 9.00000000000000e-06
0.0970000000000000 1.10000000000000e-05
0.0980000000000000 1.20000000000000e-05
0.0990000000000000 1.20000000000000e-05
0.100000000000000 1.20000000000000e-05
0.101000000000000 1.10000000000000e-05
0.102000000000000 1.60000000000000e-05
0.103000000000000 9.00000000000000e-06
0.104000000000000 1.20000000000000e-05
0.105000000000000 1.30000000000000e-05
0.106000000000000 7.00000000000000e-06
0.107000000000000 5.00000000000000e-06
0.108000000000000 9.00000000000000e-06
0.109000000000000 5.00000000000000e-06
0.110000000000000 8.00000000000000e-06
0.111000000000000 1.00000000000000e-05
0.112000000000000 1.20000000000000e-05
0.113000000000000 1.50000000000000e-05
0.114000000000000 4.00000000000000e-06
0.115000000000000 6.00000000000000e-06
0.116000000000000 1.10000000000000e-05
0.117000000000000 6.00000000000000e-06
0.118000000000000 5.00000000000000e-06
0.119000000000000 9.00000000000000e-06
0.120000000000000 8.00000000000000e-06
0.121000000000000 1.30000000000000e-05
0.122000000000000 7.00000000000000e-06
0.123000000000000 1.50000000000000e-05
0.124000000000000 1.40000000000000e-05
0.125000000000000 1.00000000000000e-05
0.126000000000000 1.10000000000000e-05
0.127000000000000 1.10000000000000e-05
0.128000000000000 1.60000000000000e-05
0.129000000000000 1.00000000000000e-05
0.130000000000000 8.00000000000000e-06
0.131000000000000 8.00000000000000e-06
0.132000000000000 1.00000000000000e-05
0.133000000000000 1.00000000000000e-05
0.134000000000000 8.00000000000000e-06
0.135000000000000 1.20000000000000e-05
0.136000000000000 1.00000000000000e-05
0.137000000000000 7.00000000000000e-06
0.138000000000000 9.00000000000000e-06
0.139000000000000 1.30000000000000e-05
0.140000000000000 1.40000000000000e-05
0.141000000000000 8.00000000000000e-06
0.142000000000000 9.00000000000000e-06
0.143000000000000 7.00000000000000e-06
0.144000000000000 1.00000000000000e-05
0.145000000000000 1.60000000000000e-05
0.146000000000000 1.20000000000000e-05
0.147000000000000 1.40000000000000e-05
0.148000000000000 1.30000000000000e-05
0.149000000000000 1.00000000000000e-05
0.150000000000000 8.00000000000000e-06
0.151000000000000 1.30000000000000e-05
0.152000000000000 1.60000000000000e-05
0.153000000000000 1.30000000000000e-05
0.154000000000000 9.00000000000000e-06
0.155000000000000 1.40000000000000e-05
0.156000000000000 1.20000000000000e-05
0.157000000000000 7.00000000000000e-06
0.158000000000000 1.20000000000000e-05
0.159000000000000 1.00000000000000e-05
0.160000000000000 1.50000000000000e-05
0.161000000000000 6.00000000000000e-06
0.162000000000000 1.30000000000000e-05
0.163000000000000 1.30000000000000e-05
0.164000000000000 1.20000000000000e-05
0.165000000000000 9.00000000000000e-06
0.166000000000000 9.00000000000000e-06
0.167000000000000 1.30000000000000e-05
0.168000000000000 1.60000000000000e-05
0.169000000000000 1.60000000000000e-05
0.170000000000000 1.40000000000000e-05
0.171000000000000 1.20000000000000e-05
0.172000000000000 1.50000000000000e-05
0.173000000000000 8.00000000000000e-06
0.174000000000000 1.10000000000000e-05
0.175000000000000 1.40000000000000e-05
0.176000000000000 1.20000000000000e-05
0.177000000000000 1.00000000000000e-05
0.178000000000000 8.00000000000000e-06
0.179000000000000 1.20000000000000e-05
0.180000000000000 1.30000000000000e-05
0.181000000000000 7.00000000000000e-06
0.182000000000000 9.00000000000000e-06
0.183000000000000 1.50000000000000e-05
0.184000000000000 1.30000000000000e-05
0.185000000000000 8.00000000000000e-06
0.186000000000000 1.30000000000000e-05
0.187000000000000 1.40000000000000e-05
0.188000000000000 1.60000000000000e-05
0.189000000000000 4.00000000000000e-06
0.190000000000000 1.00000000000000e-05
0.191000000000000 1.30000000000000e-05
0.192000000000000 8.00000000000000e-06
0.193000000000000 1.40000000000000e-05
0.194000000000000 1.10000000000000e-05
0.195000000000000 7.00000000000000e-06
0.196000000000000 8.00000000000000e-06
0.197000000000000 1.90000000000000e-05
0.198000000000000 1.10000000000000e-05
0.199000000000000 1.20000000000000e-05
0.200000000000000 1.30000000000000e-05
0.201000000000000 1.00000000000000e-05
0.202000000000000 1.00000000000000e-05
0.203000000000000 1.90000000000000e-05
0.204000000000000 8.00000000000000e-06
0.205000000000000 1.20000000000000e-05
0.206000000000000 1.00000000000000e-05
0.207000000000000 9.00000000000000e-06
0.208000000000000 7.00000000000000e-06
0.209000000000000 7.00000000000000e-06
0.210000000000000 1.70000000000000e-05
0.211000000000000 1.40000000000000e-05
0.212000000000000 8.00000000000000e-06
0.213000000000000 1.00000000000000e-05
0.214000000000000 8.00000000000000e-06
0.215000000000000 7.00000000000000e-06
0.216000000000000 1.80000000000000e-05
0.217000000000000 8.00000000000000e-06
0.218000000000000 1.10000000000000e-05
0.219000000000000 1.70000000000000e-05
0.220000000000000 1.70000000000000e-05
0.221000000000000 1.30000000000000e-05
0.222000000000000 1.00000000000000e-05
0.223000000000000 1.60000000000000e-05
0.224000000000000 7.00000000000000e-06
0.225000000000000 1.10000000000000e-05
0.226000000000000 1.20000000000000e-05
0.227000000000000 1.10000000000000e-05
0.228000000000000 7.00000000000000e-06
0.229000000000000 1.20000000000000e-05
0.230000000000000 1.70000000000000e-05
0.231000000000000 1.30000000000000e-05
0.232000000000000 4.00000000000000e-06
0.233000000000000 1.50000000000000e-05
0.234000000000000 7.00000000000000e-06
0.235000000000000 1.20000000000000e-05
0.236000000000000 1.70000000000000e-05
0.237000000000000 1.50000000000000e-05
0.238000000000000 1.10000000000000e-05
0.239000000000000 8.00000000000000e-06
0.240000000000000 1.50000000000000e-05
0.241000000000000 1.90000000000000e-05
0.242000000000000 8.00000000000000e-06
0.243000000000000 1.10000000000000e-05
0.244000000000000 1.20000000000000e-05
0.245000000000000 2.10000000000000e-05
0.246000000000000 1.10000000000000e-05
0.247000000000000 1.80000000000000e-05
0.248000000000000 1.20000000000000e-05
0.249000000000000 1.20000000000000e-05
0.250000000000000 1.40000000000000e-05
0.251000000000000 1.30000000000000e-05
0.252000000000000 9.00000000000000e-06
0.253000000000000 1.60000000000000e-05
0.254000000000000 1.00000000000000e-05
0.255000000000000 4.00000000000000e-06
Please help me thanks
2 comentarios
Dyuman Joshi
el 25 de En. de 2023
Show us your code.
The data is still in default format (double), just stored in form of a table. You need to access the Table columns properly.
Read - Access Data in a Table
Askic V
el 25 de En. de 2023
Most probably, you will have to use table2array function at some point. Please have a look at the documentation:
https://www.mathworks.com/help/matlab/ref/table2array.html
Respuestas (1)
Suman Sahu
el 9 de Mzo. de 2023
Hi SANA,
The histogram function accepts a numerical array of types: double, single, uint8, uint16, uint32, uint64, int8, int16, int32, int64, logical, datetime, duration, categorical as input argument, However, you are passing a table which results in an error. There are three ways by which you can handle this:
1. You can try to extract the column from the table you want to plot the histogram. However, in this approach you can only plot one column at a time.
%create an example table with two columns of random data
data table(randn(1000,1), randn(1000,1), 'VariableNames', {'Column1', 'Column2'});
% extract the first column as an array
x = data.Column1;
% create a histogram of the data
histogram(x);
2. You can extract part of the table as an array using table indexing as follows:
% create an example table with two columns of random data
table_data = table(randn(1000,1), randn(1000,1), 'VariableNames', {'Column1', 'Column2'});
% extract the required array
x = table_data{1:5, 2}; %this extracts the table’s rows 1 to 5 and column 2 which creates an array of dimension 5x1.
% create a histogram of the data
histogram(x);
3. You can convert the table to an array directly using the function table2array(table).
data_array = table2array(table_data);
histogram(data_array);
To learn more about the functions used above, refer to the following documentations:
- Histogram plot - MATLAB - MathWorks
- Convert table to homogeneous array - MATLAB table2array - MathWorks
- Table array with named variables that can contain different types - MATLAB - MathWorks
Hope this helps.
0 comentarios
Ver también
Categorías
Más información sobre Categorical Arrays en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!