Data imported from similar sources in Excel and or CSV. I tried different ways for translating the original dates to Wolfram Language.
In[]:=
olddata=
Out[]=
TimeSeries
In[]:=
newdata=
Out[]=
TimeSeries
The date objects of olddata and newdata are different.
In[]:=
Normal[olddata]
Out[]=
,619.31,,621.669,,623.811,,625.518,,627.92,,629.263,,632.292,,634.252,,636.815,,637.941,,640.931,,643.006,,645.541,,647.266,,648.66,,650.253,,652.629,,654.311,,656.634,,658.962,,661.652,,663.38,,665.154,,666.51,,667.404,,668.76,,669.928,,672.211,,673.707,,675.188
In[]:=
Normal[newdata]
Out[]=
,676.527,,677.546,,679.106,,680.743,,681.761,,683.197,,684.514
I joined the data, but the date stamps are not exactly the same.
In[]:=
alldata=TimeSeriesInsert[olddata,newdata]
Out[]=
TimeSeries
The last date is interpreted as September 29 and not September 30
In[]:=
Normal[alldata]
Out[]=
,619.31,,621.669,,623.811,,625.518,,627.92,,629.263,,632.292,,634.252,,636.815,,637.941,,640.931,,643.006,,645.541,,647.266,,648.66,,650.253,,652.629,,654.311,,656.634,,658.962,,661.652,,663.38,,665.154,,666.51,,667.404,,668.76,,669.928,,672.211,,673.707,,675.188,,676.527,,677.546,,679.106,,680.743,,681.761,,683.197,,684.514
Manipulation of data with Tabular and CastColumns
Manipulation of data with Tabular and CastColumns
What are the options of the “Date” format???
CastColumns[datosimportados,"Fecha"->"Date"::["Integer32","Day","Gregorian",None]]
TransformColumns[nivcutz,"Fecha"->Function[DateObject[{#Año,#Mes,#Día}]]]
In[]:=
TabularStructure[nivcutz]
Out[]=
Tabular
