Importing large files to double with a "." as a missing value
조회 수: 1 (최근 30일)
이전 댓글 표시
I have many large files in excel . I am using the excel import function but the issue is that it shows all columns as cell columns because whenever there is a missing value the cell has a dot "." instead of nan or empty cell. Changing them manually is very tedious. Is there a way to force matlab to import all columns as vector columns while replacing the "." with a nan value?
댓글 수: 2
Star Strider
2016년 11월 20일
It would be much easier to give you a specific solution if we had your file (or a representative part of it) to work with.
채택된 답변
Guillaume
2016년 11월 20일
편집: Guillaume
2016년 11월 20일
Nowadays, there's hardly any reason to use xlsread when readtable can also read excel files and is a lot more powerful.
In your particular case:
mytable = readtable('yourexcelfile.xlsx', 'TreatAsEmpty', '.')
will replace all the '.' by NaN.
edit: fixed typo
댓글 수: 3
Guillaume
2016년 11월 20일
That was a typo, the parameter was 'TreatAsEmpty'. Note that I did link the doc, so you could just have looked it up.
추가 답변 (1개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Large Files and Big Data에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!