Filter löschen
Filter löschen

How to import blanks cells as Nans

11 Ansichten (letzte 30 Tage)
Cristina
Cristina am 27 Apr. 2015
I have a file (created in excel) with >100k rows and 22 columns. Many of the cells are blanks (not zeros). If I use csvread to import the data Matlab changes the banks to zeros. I cannot first change the blanks to 99999 because excel crashes. Is there a way to make Matlab import the blanks as Nan's?

Akzeptierte Antwort

Mohammad Abouali
Mohammad Abouali am 27 Apr. 2015
a=importdata('sampledata.csv')
a =
1 2 3 4 5
1 2 3 NaN 5
1 NaN 3 4 5
1 2 3 NaN 5
1 2 3 4 5
1 2 3 4 NaN
  3 Kommentare
Mohammad Abouali
Mohammad Abouali am 28 Apr. 2015
you are welcome
Ahmed Nirjhar Alam
Ahmed Nirjhar Alam am 23 Jul. 2020
Is there any equivalent substitute for when I have a file with multiple datatypes(such as integers, doubles, strings) in different columns?

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

Stephen23
Stephen23 am 28 Apr. 2015
Bearbeitet: Stephen23 am 28 Apr. 2015
Here is a list of some functions that can import blank/missing data as NaN:
and you can find comprehensive lists of all file reading functions in the documentation:

Community Treasure Hunt

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

Start Hunting!

Translated by