Project - 2 | Data Analysis with Python | #DataScience | Cars Dataset

Enrol in our Udemy courses :

----------------------------------------------------------

----------------------------------------------------------
----------------------------------------------------------

In this video, you will learn how to work on a real project of Data Analysis with Python. Questions are given in the project and then solved with the help of Python. It is a project of Data Analysis with Python or you can say, Data Science with Python.

The commands that we used in this project :

* import pandas as pd -- To import Pandas library
* head() - It shows the first N rows in the data (by default, N=5)
* shape - It shows the total no. of rows and no. of columns of the dataframe
* fillna() - To fill the null values of a column with some particular value
* value_counts - In a column, it shows all the unique values with their count. It can be applied to a single column only.
* isin() - To show all records including particular elements
* apply() - To apply a function along any axis of DF

------------------------------------------------------

Q. 1) Instruction ( For Data Cleaning ) - Find all Null Values in the dataset. If there is any null value in any column, then fill it with the mean of that column.
Q. 2) Question ( Based on Value Counts )- Check what are the different types of Make are there in our dataset. And, what is the count (occurrence) of each Make in the data ?
Q. 3) Instruction ( Filtering ) - Show all the records where Origin is Asia or Europe.
Q. 4) Instruction ( Removing unwanted records ) - Remove all the records (rows) where Weight is above 4000.
Q. 5) Instruction ( Applying function on a column ) - Increase all the values of 'MPG_City' column by 3.

-----------------------------------------------------------------------

You must check our other videos :

#python #dataanalytics #datascience #project

[data_science_lovers]

Get our "Self Study Material", which includes all the Projects Source Codes and Notes of the complete Data Analytics course, which contain all commands of Core Python, Numpy, Pandas, Matplotlib, SQL that we use for Big-Data Analytics ( cost @ Rs.250 or $20 or €20 )

[eobaz]

Great videos sir. For those with blank issues, import file to excel, click on any cell and press Ctrl +g, special, blank, click on delete entire rows. In total we have 6 rows but 2 of the rows have values so just delete 4 and leave the two remaining cells

[unpatel]

This was a great one for a beginner like me, very light and easy going! Now time for me for the 3rd one!

[theblogger]

Excelent. Teaching skills as a biganerr I'm very much interested and it's very easy way to learn this Concept. Ur the best teacher for Phyton programing entire Youtube i like ur vedios it's amazing and ur the ideal person u know how to teach the things in concept oriented geart

[cococnk]

The delete and the apply lambda was new to me great one sir.

[jitendramishra]

I subscribed you for waiting to next project series. Thank you for this video.

[essamanbar]

Thanks, Rohit
for your valuable video tutorial...

[PavanVarma]

I see there is a minimum of 4 missing values in every column. Is this a different CSV file from which you used in the video?

[vasanthidurai]

Thank u for ur videos... Please keep posting...

[niteeshkumar]

Great job sir.. please always make it continue for us

[meditationhealingmusic]

Thank you so Much, your teaching style is Amazing. thank you for posting this videos .

[ahmadnawaz]

For 2nd question if we use " car.groupby('Make').size() " i think it will also do the same job as the code which you wrote " car['Make'].value_counts() "

[SOPHIACEO]

sir, why was my own data set have multiple NULL values, and yours have just 2. after i wrote the cars.isnull().sum
() command i ended up having NULL values in all the colums, i am so confused ryt now, i need help please.

[kishorkumars]

In the given dataset their 4 nulls in all columns hence use dis formula to remove those null values

[gospelmoto]

I get this error: [Errno 2] No such file or directory: Thanks for the video and answer to my question. File path is ok

[subarnabanerjee]

(MPG_City+3) will also yield the same result as after using the lambda function.

[vishu.thorat.]

Ya, I see there is a minimum of 4 missing value each an every columns so how to replace all null value in mean value..which command line or code use

[amitrajput]

Hi Rohit, Your videos are so helpful. Thank you so much for creating them.
I have one query in the last question instead of lambda, if we use this - car['MPG_City'] = car.MPG_City + 3
will that be a good practice or the right way?
Please suggest your thoughts on it.
In last my best wishes to you and good luck for upcoming videos.

[akshaykalamkar]

Bro it is que answer if client ask us to analyst this data and give me insight from this....then how will we give him insights by data analysis...how we can do complete report?

[nishant]

I want to do at least 2 projects for my CV and skill boost.
Could you please suggest python projects for the same?
And any specific website for projects ??
Thank You !!