Pandas Class 04 – How to Import CSV, Excel & JSON Files - video Dailymotion

Nafees AI Lab

Learn how to load data into Pandas from various file formats including CSV and Excel. #ImportData #PythonCSV #Pandas

Transcript

00:00Guys, in this lecture, we will describe the data.

00:02There is an important parameter that we call attributes.

00:07We use attributes to describe the data.

00:11Now, it is very important that the attributes of the attributes are called function.

00:17And the attributes of the function and the attributes we know here.

00:21First of all, we note that we have read CSV or to CSV followed with round brackets.

00:29So, the function of the function is basically with round brackets.

00:34And when you call the function, you need to manipulate the data.

00:38However, when you call the attribute, it is not followed by round brackets.

00:43It is not followed by a simple value.

00:45Now, let's take a example.

00:47We have the data on the phone.csv.

00:50So, if I call the phone.csv and call the types,

00:54remember that the types.

00:58This is basically the attributes.

01:01Because it is not followed by a round bracket.

01:05So, this is the data type.

01:08This is the data type.

01:10So, I will execute it.

01:12As you see, this is the two columns.

01:14Memory and SIM card are in type.

01:17And the other columns are object type.

01:19Again, this is the data type.

01:24So again, this is my data.

01:27DataFrame is in my phone.

01:28So I will execute my data.

01:33As you see, we have columns.

01:36Basically, we have value.

01:40We can assign this variable.

01:43So I will execute this.columns.

01:49Execute.

01:51If I have columns,

01:58I will display it.

01:59At the moment,

02:01if you have seen columns,

02:04this is very useful feature.

02:06If you are looking at this,

02:08you will see how important it is.

02:10Now, here we go.

02:12Here we go.

02:14Basically, index information.

02:16This is a very useful feature.

02:18This is the value.

02:21It's dataframe.

02:23I will use index.

02:27You see,

02:29index information.

02:31Zero from start,

02:3210 from stop.

02:33Step size.

02:34If you want to use statistics information,

02:37information.

02:38If you want to add data to this data, then simply describe the function of this function.

02:42Here we go, copy, control, c, control, v, dot, d, e, s, c, r, i, b, e, describe, but

02:47this method is a method.

02:50Sorry, this function is a function.

02:53So now you have to describe the function of this function.

02:57This function has only two columns, which data type int, and they have statistical information

03:06to count, mean, standard, minimum value, maximum value, and percentile values.

03:13This is a question that when we talk about price, we talk about the integer.

03:22However, price is followed by a dollar sign.

03:26And so on.

03:27And so on.

03:28And so on.

03:29And so on.

03:30And so on.

03:31And so on.

03:32And so on.

03:33And so on.

03:34So on.

03:35We have two things about values and attributes.

03:38We use this definition.

03:39Now here I have to write on the thing on the dependency.

03:41We use this order for an identity.

03:42So to say that there is an object.

03:43If it doesn't allow any value.

03:44And so on.

03:46And so on.

03:47And so on.

03:48And so on.

03:50And so on.

03:52And so on.

03:53And so on.

03:54And so on.

03:55And so on.

03:56So on.

03:57And so on.

03:59We can combine a simple method in a simple method.

04:03That is info.

04:05I will say that we can put it in a simple method.

04:07I will say that .info method.

04:09And then execute.

04:11As you guessed,

04:13I will say that we have got the spelling of the method.

04:16Now, look at that.

04:18We can do not only data type,

04:20we can do the column,

04:21we can do the indexing,

04:23and much more information.

04:25This is very cool.

04:27Mean values can be calculate.

04:30Again,

04:31we have data frame.

04:33I will say .mean function call.

04:36Sorry, means.

04:37This is mean.

04:38I will execute.

04:39This is only int columns of mean values.

04:44Int columns of mean values are displayed.

04:47Now,

04:48if you have a hypothetical time series data,

04:53I will say test is equal to

04:56pd.series with capital S.

04:59R.I.E.S.

05:00And in this series,

05:01I will generate a series.

05:03One, two, three.

05:04Execute.

05:05Test is equal to

05:06pd.series with capital S.R.I.E.S.

05:08This is so cool.

05:09This is so cool.

05:10This is so cool.

05:11Now,

05:12we can do an important work.

05:13We can do this.

05:14This is so cool.

05:15We can do this.

05:16We can do this.

05:17This is so cool.

05:35This is so cool.

05:36Now we can do a very important job.

05:38It is that we can select individual columns.

05:43Now we can do a very important job.

05:48Imagine that I want to do a mean,

05:51but I want to do a same card.

05:55This is my data frame.

05:59This is my data frame.

06:01If I put this data frame,

06:04then I put square brackets.

06:08Then I put string in the same card.

06:12I put it in time.

06:13So you can select the column.

06:15So I can select the column.

06:19I can select the column which I want,

06:21this type of column.

06:22I put a column here.

06:23I now try to select the column.

06:24Okay.

06:25If I select the column,

06:28this column,

06:29this column inside.

06:30This column is called.

06:31here.

06:32Not just this, but now you can call this function.

06:35If you can say sum, execute.

06:37Then you can say sum.

06:39If you call this sum, you can call this sum.

06:42Then you can call this sum.

06:44This is the sum return.

06:47Is this cool?

06:48It's very cool.

06:50Okay.

06:51Give it a go.

06:53Try it again.

06:55Then we will start again.

06:58Give it a go.

Pandas Class 04 – How to Import CSV, Excel & JSON Files

Category

Transcript

Recommended