Tag Info

New answers tagged

2

Suppose you have your data stored in data, you can clean up the unwanted stuff using Cases: newdata = Cases[data, {{__?NumericQ}, _}]; Then use DateListPlot to plot it: DateListPlot[newdata]


1

Suppose you have a Excel like this: The best way to import excel is through SemanticImport.(In version 10.0.0.0) mydata = SemanticImport["d:/1.xlsx"] and you will get In my computer, Mathematica does not Process Date properly,So I did this: date = Normal@mydata[All, 1]; date = StringCases[#, WordCharacter ..] & /@ date date = ...


0

(* Import your data from the Excel file *) originalData = Import["your file name here"]; (* This checks to see if the data in the first column has been broken into a 6 part list and if the data in the second column is numeric; the Select function will return items that match both criteria*) cleanData = Select[originalData, Length[#[[1]]] == 6 && ...


1

lets say your import data are rawdata = {{"Unidad Indexada", ""}, {"PerĂ­odo Junio 2002 -", ""}, {"", ""}, {"", "Valor"}, {"Fecha", "Pesos ($)"}, {"", ""}, {"", ""}, {"2 0 0 2", ""}, {"", ""}, {"Junio", ""}, {"", ""}, {{2002, 6, 1, 0, 0, 0.}, 1.}, {{2002, 6, 2, 0, 0, 0.}, 1.0004}, {{2002, 6, 3, 0, 0, 0.}, 1.0008}, {{2002, 6, 4, 0, 0, 0.}, 1.0012}, ...



Top 50 recent answers are included