I want to import an excel .csv
file and ListPlot
the data.
file = Import["Desktop/PP_1039.CSV", "Data"]
But I get this data :
(*{{"0.0472;120.9091"}, {"0.0454;113.0303"}, {"0.0441;106.6667"},
{"0.0442;106.6667"}, {"0.0437;103.3333"}, {"0.0425;95.1515"},
{"0.0409;83.6364"}, {"0.0387;72.7273"}, {"0.0354;59.697"},
{"0.0317;45.7576"}, {"0.0275;34.8485"}, {"0.0234;24.8485"},
{"0.0155;12.1212"}, {"0.0115;6.6667"}, {"0.0072;2.7273"},
{"0.0031;2.1212"}} *)
So I'd like to delete the "
and to replace ;
with ,
StringReplace
? $\endgroup$ – Henrik Schumacher Feb 1 '19 at 9:32ToExpression
(i.e. the answer you accepted) will not handle all number formats that are allowed (and often present) in CSV files, such as123.4e5
. $\endgroup$ – Szabolcs Feb 1 '19 at 11:50ReadList[file, Expression]
$\endgroup$ – user170231 Feb 1 '19 at 23:15