Hi everyone, I have certain values retrieved from mysql database.How can i do certain analysis like histogram, correlational analysis tc using this data,I tried it. But when i tried to plot a histogram it actually showed error the data is not numeric evenif it was stored as integer data type in mysql db. Please anyone help. Can anyone specify the steps for doing data analysis after retrieving data from the database. [[alternative HTML version deleted]]
Please tell us the package you are using and the specific commands. It is most likely you are retrieving the data into a list or some other structure that hist() doesn't like. On Mon, Jun 20, 2011 at 12:57 PM, amrita gs <ammasamritha at gmail.com> wrote:> Hi everyone, > > ? ? I have certain values retrieved from mysql database.How can i do > certain analysis like histogram, correlational analysis tc using this data,I > tried it. But when i tried to plot a histogram it actually showed error the > data is not numeric evenif it was stored as integer data type in mysql db. > > Please anyone help. Can anyone specify the steps for doing data analysis > after retrieving data > from the database. > > ? ? ? ?[[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >
at least provide a sample of the data. It sounds like you have 'factors' as your data. Do an 'str' of your dataframe that was returned. Sent from my iPad On Jun 19, 2011, at 22:57, amrita gs <ammasamritha at gmail.com> wrote:> Hi everyone, > > I have certain values retrieved from mysql database.How can i do > certain analysis like histogram, correlational analysis tc using this data,I > tried it. But when i tried to plot a histogram it actually showed error the > data is not numeric evenif it was stored as integer data type in mysql db. > > Please anyone help. Can anyone specify the steps for doing data analysis > after retrieving data > from the database. > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.