Rearrange a CSV file

12 次查看（过去 30 天）
Frank Lindsey
Frank Lindsey 2021-5-24
编辑： Monika Jaskolka 2021-5-30
Hello to whomever
i need to extract a specific data (columns) from a csv file and transfer to another file columns. without copying and paste
My csv file contains 20 columns with over 7000 rows, i want to extract the X colum from file abc and move it to column F in file test1.
Rearrange example: current file has ID in column H but the correct format column the ID section is in C
I am trying to think of a way for me to write code that will allow me to move columns and then grab/get rows to group them. or is there away in excel already?
Does this make sense?

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

回答（1 个）

Monika Jaskolka
Monika Jaskolka 2021-5-30
编辑：Monika Jaskolka 2021-5-30
Assuming your data has headers to identify the column names as A...X:
t1 = readtable('abc.csv');
t2 = readtable('test1.csv');
t2.F = t1.X;
If you don't want to overrwrite column F:
t1 = readtable('abc.csv');
t2 = readtable('test1.csv');
t2.newF = t1.X;
t2 = movevars(t2, 'newF', 'Before', 'F')

类别

在 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