Rearrange a CSV file
11 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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?
0 comentarios
Respuestas (1)
Monika Jaskolka
el 30 de Mayo de 2021
Editada: Monika Jaskolka
el 30 de Mayo de 2021
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')
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!