Effacer les filtres
Effacer les filtres

Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

how to merge one column dataset into big dataset file

1 vue (au cours des 30 derniers jours)
Moshe
Moshe le 22 Sep 2016
Clôturé : MATLAB Answer Bot le 20 Août 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?

Réponses (1)

KSSV
KSSV le 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 commentaire
Moshe
Moshe le 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);

Cette question est clôturée.

Tags

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by