CSV impornt, or Serial Connection?

Projects General Guidance
1

Hello guys, I have worked on a project for some time now where I have tracked GPS and PPM data around my city. Now I want to map the data onto a interactive physical map using Arduino, but I need some help to get started.

All my data is stored as several CSV files(one file for each route). Each file exist of measurement taken every two second. For each measurement a new Row is created, so the length of rows depends on the length of the route. Every row has 4 columns of data: time - latitude - longitude - ppm.

I have played a lot with the data in Processing, and it was easy for me to import the CSV data, convert it into a 2D array, and acces the different readings using the following code:

String csv[];
 String myData[][];

  
  csv = loadStrings("data.CSV");
  myData = new String[csv.length][4];
  for(int i = 1; i < csv.length; i++){
    myData[i] = csv[i].split(",");
  }

for(int i = 0; i>myData.length; i++){
 float value = float(myData[i][3]);
}

But the same technique dosen't seem to work in Arduino.

I need the measurements from column four (ppm) to affect an LED on my Arduino sketch. So my question is now:
How can I import the measurements from my CSV files into my Arduino sketch?
Can I use some similar technique to the above I have posted? Or should I use a "handshake" serial connection between Arduino and Processing to send the data?

2

What do you mean by "PPM data"

If you want to show something on a map I would have thought Processing (or any other PC language) would be a lot easier than an Arduino.

...R

3

ppm is data from a mq gas sensors. In my case air pollution. I know that processing is easier to show something on a map and I already did that. However thats not interesting for me right now. I just need to know the easiest way to get Arduino to work with my CSV dataset. The data should work as input to different analog outputs on the Arduino.

4

There is a parse example in Serial Input Basics which illustrates how to parse CSV data.

You are using ppm to mean "parts per million"

For many Arduino users it will mean "pulse position modulation" - the signal from a R/C transmitter.

Don't assume that everyone knows your acronyms.

...R