Looking for Someone Skilled in R

[sal002]

I am trying to alter an R script that does sentiment analysis to store the summarized results in MySQL (located here - https://sites.google.com/site/miningtwitter/questions/sentiment/sentiment).  Anyone willing to help out for a few satoshis?

[organofcorti]

Great link! I'll have to try package:sentiment and mine a few books.

What help do you need, exactly?

[sal002]

Great link! I'll have to try package:sentiment and mine a few books.

What help do you need, exactly?

Storing the results in MySQL (using http://cran.r-project.org/web/packages/RMySQL/index.html).  Probably real simple, just having an issue with the structure of the data into a table).

[organofcorti]

Great link! I'll have to try package:sentiment and mine a few books.

What help do you need, exactly?

Storing the results in MySQL (using http://cran.r-project.org/web/packages/RMySQL/index.html).  Probably real simple, just having an issue with the structure of the data into a table).

Sorry, never needed to use MySQL and R - I just use dataframes, lists, matrices and multidimensional arrays. I guess you're using MySQL so you can query it using other software?

[sal002]

Exactly right.  Probably real simple for someone that has used the MysQl package before.  Issue is the data structure - just not quite sure how to figure it out.  Instead of plotting (as that article does), I want to store the data.

[organofcorti]

Exactly right.  Probably real simple for someone that has used the MysQl package before.  Issue is the data structure - just not quite sure how to figure it out.  Instead of plotting (as that article does), I want to store the data.

I guess you've used R before and that saving it as a .csv or a tab delimited file is no help to you?

[sal002]

Just a little bit - but would prefer MySQL as I can access it from another system.

[organofcorti]

Well, I'm probably no use to you then, sorry. Maybe try the R mailing list or stackexchange, or if you really get stuck there might be some way to do whatever MySQL queries you wanted from within R, or calling by calling R scripts if you need it to be interactive or running on a cronjob or something.

Good luck!