Book Image

Hands-On Big Data Modeling

By : James Lee, Tao Wei, Suresh Kumar Mukhiya
Book Image

Hands-On Big Data Modeling

By: James Lee, Tao Wei, Suresh Kumar Mukhiya

Overview of this book

Modeling and managing data is a central focus of all big data projects. In fact, a database is considered to be effective only if you have a logical and sophisticated data model. This book will help you develop practical skills in modeling your own big data projects and improve the performance of analytical queries for your specific business requirements. To start with, you’ll get a quick introduction to big data and understand the different data modeling and data management platforms for big data. Then you’ll work with structured and semi-structured data with the help of real-life examples. Once you’ve got to grips with the basics, you’ll use the SQL Developer Data Modeler to create your own data models containing different file types such as CSV, XML, and JSON. You’ll also learn to create graph data models and explore data modeling with streaming data using real-world datasets. By the end of this book, you’ll be able to design and develop efficient data models for varying data sizes easily and efficiently.
Table of Contents (17 chapters)

Preprocessing and model creation

One of the frequently asked questions is, "Is it really important to scale the data?" or "When should we scale the data?" To be honest, there is no one-size-fits-all answer to this question. It really depends on the type of data you are working with and the algorithms being applied to it. An algorithm such as Support Vector Machine (SVM) converges very fast on normalized data. Another good reason to normalize the data is when the model is very sensitive to the magnitude and the units of two or different features are different. Here we are considering two important features: timestamp and price. And we are interested in finding how price changes over time.

The next step in our process is to preprocess the dataframe we created:

#pre-processing
scale=preprocessing.scale(price)

And then let's plot the scaled price:

plt.plot...