Effacer les filtres
Effacer les filtres

Convert to fixed values and replace N/A with zero?

2 vues (au cours des 30 derniers jours)
Adeline War
Adeline War le 6 Juil 2022
Commenté : dpb le 9 Juil 2022
How do I convert this data to fixed values and replace N/A with zero?
  6 commentaires
Adeline War
Adeline War le 9 Juil 2022
@dpb I want to convert scienfic notations to real number.
dpb
dpb le 9 Juil 2022
Specifically what format do you consider a "real" number? And where is this formatting to take effect -- at command line (see format for that) or writing an output file or...???

Connectez-vous pour commenter.

Réponse acceptée

Pratyush Swain
Pratyush Swain le 6 Juil 2022
I believe by "converting to fixed number" you are trying to convert the scientic notation to real number notation.
%read the data%(This automatically coverts the numbers from scientic notation to floating point)
data=readtable("micro.txt");
%fill missing data%
data=fillmissing(data,'constant',0);
%write the table data to new file%
writetable(data,'micro_new.txt');
So the above 3 lines entails the following process
1-Sample Data
2-Imported table data after reading
3-Fill missing values
4-Write updated values to file
Hope this helps.
  4 commentaires
Adeline War
Adeline War le 9 Juil 2022
@dpb max function does not work for a table format. I had to covert it to cell using table2cell and then cell2mat to use the max function.
dpb
dpb le 9 Juil 2022
Modifié(e) : dpb le 9 Juil 2022
Nonsense. Read the doc on referencing table variables. See <table> and <Access Data in Tables>, the latter is a link in the preceding doc for table that shows how to use one once you have it.
You really wouldn't think TMW would build the table class and have no way in which to reference it, would you? There is a "veritable plethora" of addressing options and additional functionality associated with the table and timetable classes--but you've got to spend a little effort on your own and read/study the documentation for syntax and then look at the example code for illustration and to get an idea about some of the features that are therein.
And, don't overlook the links at the top of the doc page on Functions and the See Also section at the bottom of the page that shows you the most closely related other functions you're likely to find useful if you're using the specific function.

Connectez-vous pour commenter.

Plus de réponses (2)

Rik
Rik le 6 Juil 2022
Perhaps the strrep function does what you need.
data=readlines('https://www.mathworks.com/matlabcentral/answers/uploaded_files/1057030/micro.txt');
data=data(1:30);
data=strrep(data,'N/A',' 0')
data = 30×1 string array
"id,value" "44, 0.000E+00" "526, 6.464E-03" "527, 0.000E+00" "529, 0.000E+00" "530, 6.332E-03" "532, 6.838E-03" "542, 0.000E+00" "886, 0" "887, 0" "888, 0" "889, 0" "890, 0" "891, 0" "892, 0" "893, 5.030E-03" "894, 0" "895, 7.226E-03" "896, 8.863E-03" "897, 0" "898, 7.015E-03" "899, 6.572E-03" "900, 0" "901, 0" "902, 6.896E-03" "903, 6.118E-03" "904, 0" "905, 0" "906, 0" "1047, 0.000E+00"
  2 commentaires
Adeline War
Adeline War le 9 Juil 2022
Yes, it does. Thank you. I get 1 column with numbers of type string. How do I divide these into two columns?
dpb
dpb le 9 Juil 2022
Read the data file as numeric to begin with and you won't need to.
But, we just solved that problem in the other topic -- "split" if there were some real reason (hard to imagine what it would be) to read as text.
You can always write the numeric data back out in text files; there's no sense in making working with numeric data in memory more difficult than needs be.

Connectez-vous pour commenter.


dpb
dpb le 6 Juil 2022
As @Rik, I have no klew what fixed values are to be, but the other Q? is trivial --
  1. Brute force...
data=readtable('micro.txt');
data.value(isnan(data.value))=0;
2. Use builtin paramters on input...
data=readtable('micro.txt',"EmptyValue",0);

Catégories

En savoir plus sur Data Type Conversion dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by