How to import blanks cells as Nans
10 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Cristina
il 27 Apr 2015
Commentato: Ahmed Nirjhar Alam
il 23 Lug 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 Commenti
Risposta accettata
Mohammad Abouali
il 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 Commenti
Ahmed Nirjhar Alam
il 23 Lug 2020
Is there any equivalent substitute for when I have a file with multiple datatypes(such as integers, doubles, strings) in different columns?
Vedere anche
Categorie
Scopri di più su Standard File Formats in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!