How do I convert the binary valued column to decimal?

Question

Jay Vaidya 2020-4-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/521291-how-do-i-convert-the-binary-valued-column-to-decimal

评论： darova 2020-5-16

just_adder_1p2_ABS_matlab.csv

cadence_data = readtable('just_adder_1p2_ABS_matlab.csv','ReadVariableNames',0);
cadence_data = cadence_data{:,:};
cadence_data(1,:) = [];
%% bi2de
% [rows_A cols_A] = size(cadence_data);
cadence_data = cellfun(@str2double,cadence_data);
for i = 1:1:size(cadence_data,1)
    
    cadence_data(i,7) = bi2de(cadence_data(i,4));
    
end

Error:

Error using bi2de>validateInputs (line 81)
The elements of the matrix are larger than the base can represent.
Error in bi2de (line 35)
  [b_double, inType, p, msbFlag] = validateInputs(b, varargin{:});
Error in cadence_just_adder (line 15)
    cadence_data(i,7) = bi2de(cadence_data(i,4));

The excel file attached has binary valued cells (columns 2,4 and 6). How can I convert those 16 bit binary bits in to decimal values?

Thanks in advance

2 个评论
显示无隐藏无

darova 2020-4-28

在 MATLAB Online 中打开

Part of your data

S X,S LogicBus,A X,A LogicBus,B X,B LogicBus
0,1.101E+15,0,1.11011E+14,0,1.11111E+15
5.32E-11,1.11111E+15,5.00E-09,1.00001E+13,5.00E-09,1.10001E+15
8.78E-11,1.01111E+15,1.00E-08,1.01E+15,1.00E-08,1.11001E+13

Don't see any binary data

Jay Vaidya 2020-4-28

编辑：Jay Vaidya 2020-4-28

It is a 16 bit binary data

For example:

1.01111E+15 when you see as a expanded column in excel, it will be 101111....

请先登录，再进行评论。

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

Answer 1

darova 2020-4-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/521291-how-do-i-convert-the-binary-valued-column-to-decimal#answer_428994

在 MATLAB Online 中打开

Try this

A = readtable('just_adder_1p2_ABS_matlab.csv');
A1 = table2array(A(:,2));
A2 = bin2dec(num2str(A1));

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

sarah emi 2020-5-16

thanks for the soultion , Programming is not an easy to do . I search solution on many websites . Finally found on here . I do programming with logo designing in uae so we need some sugestion when we stuck in to problems .

darova 2020-5-16

What can help you with?

请先登录，再进行评论。

Answer 2

KSSV 2020-4-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/521291-how-do-i-convert-the-binary-valued-column-to-decimal#answer_428825

Load data from csv files using csvread.
Use the function bin2dec to convert binary to decimal.

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

KSSV 2020-4-28

Try with xlsread, readtable.

Jay Vaidya 2020-4-28

在 MATLAB Online 中打开

I get the following error

Error using bi2de>validateInputs (line 81)
The elements of the matrix are larger than the base can represent.
Error in bi2de (line 35)
  [b_double, inType, p, msbFlag] = validateInputs(b, varargin{:});
Error in cadence_just_adder (line 15)
    cadence_data(i,7) = bi2de(cadence_data(i,4));