Merging of two csv files

1 次查看(过去 30 天)
Anil Kumar
Anil Kumar 2019-2-18
回答: KSSV 2019-2-18
Hi,
I have 2 big excel (csv files) of columns & rows ..The values contain diffent type of groups. For example, 1 to 10 rows belongs to one ID and then 11 to 14 rows belongs to another catogery of ID and so on ... I have 60 thousands of catogiries with several number of rows & columns.
From 1st Big excelfile ( CSV file): I need to collect the data of one ID programmically and put this data into small excel sheet
From 2nd Big file excelfile ( csv file) : I need to collect the data of one ID programmically and put this data into small excel sheet.
Now: I have 2 small excelsheets.
I need to combine them.
THIS PROCESS SHOULD BE CARRIED OUT FOR EVERY INDIVIDUAL ID.
I request you to somebody could provide the thoughts and incase of example code to discuss on.
Your suggistions would be highly valuable and welcome.

回答(1 个)

KSSV
KSSV 2019-2-18
Read about readtable and join

Community Treasure Hunt

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

Start Hunting!

Translated by