How to read mixed string and number data from csv in matlab and manipulate

Question

I'm looking to write a script for MATLAB that will import data from a csv file which has a first row containing string headers and the data in each of those columns is either string, date or numeric.

I want to then be able to filter the data in MATLAB according to instances of a particular string and number combination.

Any help appreciated!

Cheers!

brainkz · Accepted Answer · 2015-12-02 12:19:33Z

1

I would recommend you to start with reading MATLAB documentation.

[num,txt,raw] = xlsread('myExample.xlsx')

Reads numeric, text and combined data, so, if your data is combined, then you need the cell array raw. After that, you do whatever you want with your cell array (Additional information is not provided since OP did not provide any specific information about the way the data would be filtered)

answered Dec 2, 2015 at 12:19

brainkz

1,34510 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stat-R · Accepted Answer · 2016-02-29 17:18:40Z

0

Try using readtable function in MATLAB. It correctly imports csv file with header and mixed data type.

xlsread was imported by mixed csv file very incorrectly repeating the some rows while maintaining the same total rows.

I got this after searching for a long time: MATLAB Central Question/Answer

answered Feb 29, 2016 at 17:18

Stat-R

5,3288 gold badges47 silver badges71 bronze badges

Collectives™ on Stack Overflow

How to read mixed string and number data from csv in matlab and manipulate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related