Help for a novice importing data

General Discussion Other

kevintdame

Help for a novice importing data

in General Discussion • Other • 1 year ago

Hi. I'm new to processing and need some help. I've got a csv file that contains both text and numbers. The data file looks something like this:

Column A      Column B
Jones            7
Smith            10
Harrison         3

I'd like my program to be able to import this data and use it to do things like:

- use the numbers in column B to rank order the people
- print the people's names in rank order

So I'd want my program to generate (and display on screen when run) the following:

Smith 10
Jones 7
Harrison 3

I've been looking around at different tutorials and posts, trying to understand things like loadstrings, but can't seem to figure this out. Can anyone help me out with some advice or even better some code?

Thanks a ton!

Kevin

Replies(3)

Chrisir

Re: Help for a novice importing data

1 year ago

possibly your data is separated by tabs

that could help you

http://processing.org/learning/topics/loadfile1.html

or

http://processing.org/learning/topics/loadfile2.html

then show your code what you have so far

kevintdame

Re: Help for a novice importing data

1 year ago

Thanks! I've seen those posts but can't seem to figure it out to even start writing code. Lots of the examples seem to be about accessing data as integers and drawing points with them. But I want to display strings of text from the csv file, and then rank order them based on the integer. I am hoping this is actually fairly simple and not too many lines of code. But just aren't sure how to start or even where to start. For example, do I use the loadstrings command? Finally, with respect to the data, I can make the data separated by commas or tabs - It's only a 4 row, 2 column data set because I'm just trying to figure this out (once I do I'll use a larger data set). Thanks again for the help! Kevin

amnon.owed

Re: Help for a novice importing data

1 year ago

Check out PhiLho's examples in this thread.

You can store the information for each person in an object and then have a custom Comparator to sort them.

Indeed you can use loadStrings and splitTokens to get the information in correctly.