Selecting specific columns to import from a CSV

2 次查看（过去 30 天）
Stanley Kubrick
Stanley Kubrick 2015-2-12
回答： sathish kumar rb 2017-11-11
The data I import from my GPS is formatted as CSV files with the following headers:
ID, Session_ID, Heading, Altitude, Latitude, Longitude, Created_DateTime
I only need the Latitude and Longitude values in columns 5 and 6. Is there any way of achieving this?
Currently I delete the last column manually in excel (Created_DateTime) and then use:
data = csvread('gps.csv',1,4);
This returns my latitude/longitude data but I'm wondering if there is a way of doing this without having to manually delete the Created_DateTime column in excel?

请先登录，再回答此问题。

采纳的回答

dpb
dpb 2015-2-12
fmt=[repmat('%*f',1,4) repmat('%f',1,2) '%*[^\n]'];
fid=fopen('gps.csv');
data=cell2mat(textscan(fid,fmt,'collectoutput',1));
fid=fclose(fid);
See
doc textscan % for details...
  3 个评论
显示 1更早的评论
Stanley Kubrick
Stanley Kubrick 2015-2-12
Actually just found a "Generate Script for Selection" under an Import button, thanks for your help though!

请先登录，再进行评论。

更多回答（1 个）

sathish kumar rb
sathish kumar rb 2017-11-11
hi need to select a specific colomns and rows copy one to another csv file how

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by