How do I select certain columns to import, from a table using the import tool? e.g. I want to import column A, D and U

21 次查看（过去 30 天）
Abdullah KHAN
Abdullah KHAN 2020-11-5
评论： Naif Alsalem 2020-11-5
How do I select certain columns to import, from a table using the import tool?
e.g. I want to import column A, D and U
I'm completely new to Matlab and am not sure as to the best way to import data onto Matlab. I'm looking at 'Coronavirus Pandemic Cases by Country' and only need data of cases from: Australia, China, Italy, the United States, Brazil, and Zambia.
The document is a .xlsx file.
  2 个评论
Naif Alsalem
Naif Alsalem 2020-11-5
You could do it this way:
1- Copy all the data and paste them in a file and maybe call it data.txt
2- Make sure the data.txt file is in your matlab path
3- try these basic lines to call your columns
load 'data.txt';
A=data(:,1); %calling column A -- Number 1 means that A is the 1st column
B=data(:,2); %calling column D -- Number 2 means that B is the 2nd column

请先登录，再进行评论。

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by