How to import blanks cells as Nans
8 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Cristina
el 27 de Abr. de 2015
Comentada: Ahmed Nirjhar Alam
el 23 de Jul. de 2020
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?
0 comentarios
Respuesta aceptada
Mohammad Abouali
el 27 de Abr. de 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 comentarios
Ahmed Nirjhar Alam
el 23 de Jul. de 2020
Is there any equivalent substitute for when I have a file with multiple datatypes(such as integers, doubles, strings) in different columns?
Ver también
Categorías
Más información sobre Standard File Formats 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!