Hello and welcome to the very first session of this Amazon data, Alice's project in which we are going
to perform data analysis and data processing, lots of data cleaning to analyze this huge chunk of Amazon
data.
And then we all have come up with some meaningful insights.
So this is exactly my job with a notebook idea where I'm going to code in Python programming language.
So very first I have to import my all the necessary modules over here, or I can say all the necessary
modules and classes over here so very fast.
I'm just going to import my findings and I'm going to create ideas as speedy for data manipulation,
for data stacking, for data filtering.
Lots of use cases can be easily solved by using these bonders modules after it.
I'm going to import my name by module.
So I'm going to say import no and I'm going to create its areas as an IP and after it for widgets and
stuff, I am going to import my explorative and Seabourne as well.
So here I'm just going to import my matplotlib dot by plot, which is exactly my python plot S.P.C.A.
After it, I have to also import my seabourne, which is a little bit advanced with the addition library.
So I'm going to say it's nothing but Seabourne as Ascendis so just executed it.
Now what you have to do ready.
First you have to read your data wherever your data will be, whether it will be used in databases,
whether it will be in use, some of the APIs or in some frameworks, whether it will be in some big
data frameworks like how group Apache Hive, Apache pick wherever it will be.
You have to read that data because that's how you are going to work on the real world.
Expect you don't have data or you might not have data in the form of reformat.
So at that time you have to read that data because most of the time your data will be in your database
because companies like Manses or whether it will be top notch companies, they prefer to store their
data in some databases.
Similarly, over here, if you will, see, this is exactly the database where you have all your data
as well as you have also data, any form of CSP, which is exactly the same use DOT CSC.
But anyhow, you have to read this data from this database so you will observe its extension is not
a skew light.
It means this data is stored in Ashkali database.
So now you need your askew light compiler to open this database.
Either you can download in offline mode, then either you can download that compiler and open this database
over there, or you can also go to Google and you have to just Google as Escalada online compiler.
Yeah, online.
Ask that compiler, whatever it will be, and you have to just click on this very first hyperlink.
And this is exactly the interface for which I am talking about.
You will see whatever it is exactly you're asking like online compiler and here you have an option as
file.
Just go there, click on Open Database and it will go to this page.
You have to just select the part.
And this is my Amazon dataset and this is exactly that database.
You have to just open it.
It will take some couple of seconds to open this database.
Now, you will observe your database gets open over here.
And this is exactly the table, because this is exactly my relational database.
And data is all about whenever your data is going to be stored in the form of tables in the form of
rows and columns.
Similarly were here.
All your data is exactly stored in these reviews tables.
And if you are going to click on this, you will see all your data.
Is this, this, this.
These are all the columns in your database.
And if you have to visualize this data or if you want to show this data, you have to just run this
study, select estar from then you have to give your table lims here.
My table name is nothing but reviews and you have to just press enter over here and you have to select
this run over there and it will run this query.
So what exactly the meaning of this select is start from reviews.
It means you have to select all rows, all columns from this particular table that you have in this
database.
Now you will feel right over here.
This is exactly the data on which you have to perform certain kind of analysis.
You will see over here.
This is the very huge data.
You will see how much a number of rules I have approx very values you will observe here.
So you have to load this data in your Jupiter book because you have to do a lot of people sending.
You have to do a lot of analysis on the data and then you have to come up with some meaningful insight
from this.
Chunk of data so far, this very first, you need some external modules, so I'm just going to import
my askew light tree and after it I have to just execute it.
And very first, you have to establish your connection to this database.
So for this what you guys can do, you have to very close access this module, which is exactly your
escalatory.
So I'm just going to say it's like three.
And here you have a function, which is exactly my connect function.
And here very first, you have to mention to what database you have to connect to what database you
have to establish a connection.
So I'm just going to copy this part and I'm just going to paste over there and here if I'm going to
press tab.
This is exactly that database of which I'm talking about.
Let's say I'm going to store its object and see or and or connection, whatever you want.
It's all up to you.
Just executed.
All this stuff gets executed.
And if I'm going to show you what exactly the type of this now you will observe, it is an object of
this class disconnection class over here.
Now, what you have to do, you have to read data.
You have to read your data from this database using your partner's module.
So I'm just going to say PD dot, read, underscore, you have to just step, underscore, Eskew and
underscore as you.
And this is exactly that function here.
You have to say select.
Oh, you have to say select star from whatever your table name of your database, which is exactly my
reviews.
So here I am going to say Slackistan form reviews and here you have to mention that connection that
you have established over here, which is exactly in my SEO and or you can see Conexion.
Know what you guys can do.
Let's say it will send me some data frame.
So I'm just going to store it in, let's say, some days of solitary, whatever data frame name you
want to assign.
Now you have to just execute the search.
It will take some couple of seconds because you will observe this database is very huge.
It means it will somewhere take one or two minutes depending upon what processor you are using, depending
upon what goes on of processor.
You have what ram you have worked hard disk you have.
It's all up to that.
So all this stuff gets executed.
And if I'm going to call, I had to get a preview of it.
I think you will observe this is a data frame on which you have to do certain kind of analysis.
And if I am going to call shape order.
So this is exactly the number of roles in my data and this is exactly the number of columns in my data.
Let's say I need some, let's say only three rows from this database.
So either we can call this come on as well, select a from reviews.
And here I'm going to say limit three.
It means I just need three rows from this table, lets it just execute it.
This is exactly the top three rows of my data frame.
Similarly, if I'm going to pass here, five will observe.
These are my top five rows and by calling the Abdulahad still I have my top five rows.
So these are almost similar operation.
So if you are very much familiar with your actual database or any of the database, so this escalated
just like a piece of cake, literally, just like a piece of cake.
And if you want to read this data, this data said you have to just call this real safety function from
despondence model, which is exactly my read underscores the ASV.
And here you have to mention your part, which is exactly this one.
So I'm just going to copy from here and just going to paste from here and just press tab.
And this is exactly the dataset of which I'm talking about.
So it will also give me my data frame that what this query will give us if I'm going to execute it,
it will take some couple of seconds in its execution, depending upon what the specifications you have.
You will figure out what here this is exactly that entire data frame on which you have to perform certain
kind of analysis.
So you will figure out there are two ways to read your data in this use case, because here you have
data in your database as well as in your case before.
But if you will ask my advice or my solution, I will always ask you to go ahead with this database
approach, because whenever you are, we do work from some real personal use.
Maybe you have your data from some databases or maybe you have data in some, let's say in some big
data sources like Hadoop, like Apache HYP, like Apache big.
So you have to extract that data from such a number of big data sources.
So at that time, at the time this established.
And this country will play a very major role over here.
So that's why I'm going to suggest you always go ahead with this discovery and this this blocks, of
course, whenever you have data in the form of some database.
So that's all about the search and hope.
You love it very much.
Thank you.
Have a nice day.
Keep learning.
Keep going.
Keep in.