How to import blanks cells as Nans
10 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
採用された回答
Mohammad Abouali
2015 年 4 月 27 日
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 件のコメント
Ahmed Nirjhar Alam
2020 年 7 月 23 日
Is there any equivalent substitute for when I have a file with multiple datatypes(such as integers, doubles, strings) in different columns?
参考
カテゴリ
Help Center および File Exchange で Standard File Formats についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!