Last post, I introduced about how to handle unstructured data using python programming. This time, I am going to reuse the result file which was generated by python programming.
Last time, I've uploaded test file data into R platform by using read,csv command. However, in this case, I am going to use MYSQL database as a data source for analysis.
Most company stores invaluable data into the specific database. So I think, data manipulation using database should be regarded as an common thing for data mining.
Now, let me start it one by one.
First , create a specific table on the MYSQL database.
In my case, I've installed MySQL server version (5.5.3) in my linux system and create the specific table schema for storing datafile.