Clear Filters
Clear Filters

Histogram from a table data / or convert table data into numeric

113 views (last 30 days)
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 Comments
Dyuman Joshi
Dyuman Joshi on 25 Jan 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.
Askic V
Askic V on 25 Jan 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

Sign in to comment.

Answers (1)

Suman Sahu
Suman Sahu on 9 Mar 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:
Hope this helps.

Categories

Find more on Categorical Arrays in Help Center and File Exchange

Products


Release

R12.1

Community Treasure Hunt

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

Start Hunting!