Summary
Keywords
Full Transcript
đ© Download All 15 Projects Source Codes + Datasets : https://rzp.io/rzp/all15projects Download Dataset - https://drive.google.com/file/d/1h6_m-0giAyBFkjXNMkwycJ6Zva19Bm2D/view?usp=sharing đConnect with me on LinkedIn - https://www.linkedin.com/in/rohit-grewal đPurchase - Python Data Analysis Self Study Notes & All Projects Source Codes (Rs.499 only) - https://rzp.io/l/dslnotes239 đDownload Project (Python Code & Dataset) - https://rzp.io/l/project7sourcecode Download - Python Pandas Notes ( Rs.50 ) - http://bit.ly/3KxMpgA --------------------------------- Watch our videos in Hindi on new channel: https://www.youtube.com/@ITCoursesEasy --------------------------------- đEnroll in our Udemy courses : 1. Python Data Analytics 13 Projects - https://www.udemy.com/course/bigdata-analysis-python/?referralCode=F75B5F25D61BD4E5F161 2. Python For Data Science - https://www.udemy.com/course/python-for-data-science-real-time-exercises/?referralCode=9C91F0B8A3F0EB67FE67 3. Numpy For Data Science - https://www.udemy.com/course/python-numpy-exercises/?referralCode=FF9EDB87794FED46CBDF ------------------------------------ đJoin Facebook Group - https://www.facebook.com/groups/datasciencelovers đJoin WhatsApp Group - https://chat.whatsapp.com/JKBkj7Lc9Ba6ZpzVSP5N4O đJoin LinkedIn Group - https://www.linkedin.com/groups/9247278 đFollow on Instagram - https://www.instagram.com/data_science_lovers Contact Mail Id : [email protected] ---------------------------------------- Download Free Core Python Notes - https://datasciencelovers.graphy.com/products/Core-Python-Notes-64d116f7c7a9985f7b99a5bf?dgps_s=dsh&dgps_u=c&dgps_uid=64cb5694e4b000cf748a30c2&dgps_t=cp_m --------------------------------------- In this video exercise, Udemy Courses Dataset is analyzed in a very Easy To Understand (ETU) language. Here, you will learn about the python commands & 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 functions/commands. The commands that we used in this project : * import pandas as pd -- To import Pandas library. * pd.read_csv - To import the CSV file in Jupyter notebook. * head() - It shows the first N rows in the data (by default, N=5). * unique( ) - It shows the all unique values of the column. * value_counts - In a column, it shows all the unique values with their count. It can be applied to a single column only. * df[df.Col_1 = = âElement1â] - Filtering â We are accessing all records with Element1 only of Col_1. * df.sort_values(âCol_name' , ascending=False ) - To sort the dataframe wrt any column values in descending order. * df[ (df.Col1 = = âElement1â) & (df.Col2 == âElement2â) ] - Multilevel filtering - And Filter â Filtering the data with two & more items. * str.contains('Value_to_matchâ) - To find the records that contains a particular string. * dtypes - To show datatypes of each column. * pd.to_datetime(df.Date_Time_Col) - To convert the data-type of Date-Time Column into datetime[ns] datatype. * dt.year - Creating a new column with only year values. * df.groupby(âCol_1â)['Col_2'].max() - Using groupby with two different columns. .......................................................... Q. 1) What are all different subjects for which Udemy is offering courses ? Q. 2) Which subject has the maximum number of courses. Q. 3) Show all the courses which are Free of Cost. Q. 4) Show all the courses which are Paid. Q. 5) Which are Top Selling Courses ? Q. 6) Which are Least Selling Courses ? Q. 7) Show all courses of Graphic Design where the price is below 100 ? Q. 8) List out all the courses that are related to 'Python'. Q. 9) What are courses that were published in the year 2015 ? Q. 10) What is the Max. Number of Subscribers for Each Level of courses ? ------------------------------------------------------ You must check our other Data Analytics Projects : Project 14 - Salary Data Analysis - https://youtu.be/TLIotspGcng Project 13 - HR Data Analytics - https://youtu.be/fykrwQD3HR4 Project 12 - AI Market Financial Data Analysis - https://youtu.be/WmJYHz_qn5s Project 11 - Airlines' Flights Data Analysis - https://youtu.be/gu3Ot78j_Gc Project 10 - Spotify-YouTube Data Analysis - https://youtu.be/xqtbBosGMl0 Project 9 - https://youtu.be/dQwnyCEZ-UU Project 8 - https://youtu.be/b7Kd0fLwgO4 Project 7 - https://youtu.be/AO5uhxa1R84 Project 6 - https://youtu.be/e1zKFSrKeLs Project 5 - https://youtu.be/q-Omt6LgRLc Project 4 - https://youtu.be/89eYAAPyRfo Project 3 - https://youtu.be/GyUbo45mVSE Project 2 - https://www.youtube.com/watch?v=fhiUl7f5DnI Project 1 - https://youtu.be/4hYOkHijtNw #python #dataanalytics #datascience #project
