Java code to parse 5,000 movies attributes

The first step of the project is to pre-process the data. As the data table contains multiple values in one cell, it cannot be used for MySQL relations. In order to use the data in any DBMS, you have to pre-process it.

To parse the data, use Java code. Once parsed, store the parsed CSV file(s) on your local machine for future use. Remember that, parsing is done only once, but the parsed data can be used as many times as we want.

Submission: Submit the code to parse the data along with the parsed data. Note that, you are creating any table inside MySQL at this point. You are preparing a code that you will use later for parsing the data and importing into the MySQL database.

Your code design will also affect your final product. Be sure to keep the final goal (recommendation engine) in mind while designing any component of the project.


Following is an example of attribute "genres" of the movie Avatar. Your code should be able to parse it and extract the genre names and id's.

[{"id": 28, "name": "Action"}, {"id": 12, "name": "Adventure"}, {"id": 14, "name": "Fantasy"}, {"id": 878, "name": "Science Fiction"}]

Skills: Java, MySQL

See more: how to parse html in java, extract text from html java, java html parser tutorial, jsoup parse html example, jsoup select, jsoup get element by id, jsoup get attribute value, jsoup parse url, java code mobile stream client, java code parse text file database, java code parse log files error, java code parse text file, java code parse flat file, java code parse file, java code read data text file parse, java code parse text files, sample code parse text file java, java code parse letters, java code parse lines text file, example java code parse microsoft word

About the Employer:
( 8 reviews ) melbourne, United States

Project ID: #17960009

Awarded to:


I have the necessary skills for this, I am ready to do it right now. It will take a couple of hours if too much. I will give you the result exactly as you requested.

$35 USD in 0 days
(1 Review)

6 freelancers are bidding on average $30 for this job


Hi I have great experience in java development and I can do this task according to your given requirements. Please inbox me for more discussion. Thanks

$25 USD in 1 day
(30 Reviews)

Hi, I'm a software developer with over 5 years of experience working with numerous tools and technologies including java. I'm interested in this project and would like to discuss it further with you. thanks, tofii

$55 USD in 3 days
(30 Reviews)

Hello sir, I am expert developer and designer. I have already done xlxs to MySQL data import. And I think it would be same for csv file format. Remaining thing to do is parsing the data before sending it to MySQL and c More

$25 USD in 3 days
(4 Reviews)

I'm an expert in handling objects and parsing data. Firebase JSON, API objects, databases sql and more. I won't make tall claims, I can just easily do this. Let's collaborate regards

$10 USD in 1 day
(0 Reviews)
$30 USD in 7 days
(0 Reviews)