Summary
Keywords
Full Transcript
📩 Download All 15 Projects Source Codes + Datasets : https://rzp.io/rzp/all15projects Download Dataset - https://drive.google.com/file/d/1sKOj0Dh9rWb2nhfNfJNI4hwf2IUz2kGK/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/project6sourcecode 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, India Census 2011 data 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 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 * style.hide_index( ) - To hide the index of the dataframe. * style.set_caption('Description of the dataframe') - To give a caption to the dataframe. * isin( ) - To show all records including particular elements. * groupby(‘Col_1’)[‘Col_2’] .sum( )[‘value’] - GroupBy – Two Keys – Apply on Col_2 grouped by Col_1. * df[df.Col_1 == 'Element1']['Col_2'] - Filtering - Filter the records of the dataframe wrt to Element1 of Col1 and then showing results of Col2 only. * set_index( ‘Col_Name’ ) - To set any column of a DF as an index. * add_prefix(‘value_’) - To add prefix to the column name. * add_suffix(‘_value’) - To add suffix to the column name. ....................................................................... Q. 1) How will you hide the indexes of the dataframe. Q. 2) How can we set the caption / heading on the dataframe. Q. 3) Show the records related with the districts - New Delhi , Lucknow , Jaipur. Q. 4) Calculate state-wise : A. Total number of population. B. Total no. of the population with different religions. Q. 5) How many Male Workers were there in Maharashtra state ? Q. 6) How to set a column as index of the dataframe ? Q. 7a) Add a Suffix to the column names. Q. 7b) Add a Prefix to the column names. ------------------------------------------------------ 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
