Filter löschen
Filter löschen

Info

Diese Frage ist geschlossen. Öffnen Sie sie erneut, um sie zu bearbeiten oder zu beantworten.

how to merge one column dataset into big dataset file

1 Ansicht (letzte 30 Tage)
Moshe
Moshe am 22 Sep. 2016
Geschlossen: MATLAB Answer Bot am 20 Aug. 2021
i am importing big excel file with dates and data into MATLAB. i am using MAC while the Excel is imported to matlab the dates column is corrupted. i sucsses fixing the corrupted dates in different dataset column. now i wanted the replace the corrupted dataset dates column with the fixed one and merge it to the all other data. how can i do it?
for example:
ds1= all data imported from the excel file and transform into dataset, but in this file the first column is the dates with the corrupted dates. Size of ds1 = 373x14 ds2 = this is only one column with the fix dates. Size of ds2 = 373x1
how i merge ds2 into ds1 and keep them stay as dataset?

Antworten (1)

KSSV
KSSV am 22 Sep. 2016
As the rows in ds1 and ds2 are same. You can replace the first column or merge easily.
Replace:
ds1(:,1) = ds2 ; % replaces corrupted dates with corrected dates
  1 Kommentar
Moshe
Moshe am 22 Sep. 2016
the two ds are the same length. now i got this error from Matlab:
Error using dataset/subsasgnParens (line 133) Subscripted assignment dimension mismatch for dataset variable 'Date'.
Error in dataset/subsasgn (line 79) a = subsasgnParens(a,s,b,creating);

Diese Frage ist geschlossen.

Tags

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by