Borrar filtros
Borrar filtros

Info

La pregunta está cerrada. Vuélvala a abrir para editarla o responderla.

how to merge one column dataset into big dataset file

1 visualización (últimos 30 días)
Moshe
Moshe el 22 de Sept. de 2016
Cerrada: MATLAB Answer Bot el 20 de Ag. de 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?

Respuestas (1)

KSSV
KSSV el 22 de Sept. de 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 comentario
Moshe
Moshe el 22 de Sept. de 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);

La pregunta está cerrada.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by