Title: Looking for Someone Skilled in R Post by: sal002 on April 23, 2013, 11:39:30 AM 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?
Title: Re: Looking for Someone Skilled in R Post by: organofcorti on April 23, 2013, 11:43:11 AM Great link! I'll have to try package:sentiment and mine a few books.
What help do you need, exactly? Title: Re: Looking for Someone Skilled in R Post by: sal002 on April 23, 2013, 12:00:27 PM 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). Title: Re: Looking for Someone Skilled in R Post by: organofcorti on April 23, 2013, 12:09:53 PM 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? Title: Re: Looking for Someone Skilled in R Post by: sal002 on April 23, 2013, 12:11:34 PM 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.
Title: Re: Looking for Someone Skilled in R Post by: organofcorti on April 23, 2013, 12:12:50 PM 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? Title: Re: Looking for Someone Skilled in R Post by: sal002 on April 23, 2013, 12:14:17 PM Just a little bit - but would prefer MySQL as I can access it from another system.
Title: Re: Looking for Someone Skilled in R Post by: organofcorti on April 23, 2013, 12:26:34 PM Well, I'm probably no use to you then, sorry. Maybe try the R mailing list (http://www.r-project.org/mail.html) 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! |