Pandas loc vs iloc | Select Multiple Rows and Columns From Pandas DataFrame

In this video we will learn how to slice and dice data from pandas DataFrame using loc and iloc methods. Here is the script to create the dataset.
import pandas as pd
emp= {"name":["Ankit","Rahul","Priya","Neeta"],"gender":["Male","Male","Female","Female"], "email":["[e-mail]","[e-mail]","[e-mail]","[e-mail]"] }
df = pd.DataFrame(emp)
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregat...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN ba...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL P...
Data Analyst Spotify Case Study:
• Data Analyst Spotify C...
Top 10 SQL interview Questions:
• Top 10 SQL interview Q...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question...
Playlist to master SQL :
• Complex SQL Questions ...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_...
#python #pandas #analytics

[@zulfiquarshaikh3461]

superb explanation crisp and clear. Thank you Ankit !

[@sahilsood2028]

Hi Ankit, I'm following your sql videos from long time and it also help me alot in cracking some interviews. If it's possible can you make a video in query optimization technique and performance optimization. It will be very helpful 🙂

[@as-youtuber6215]

Hi Ankit, Can you please create a video on SQL merge. I see this in all of the data engineering project. Still didn't understand. Btw your Python live classes are very informative

[@ankitbansal6]

Sure will do

[@UPESUBHADEEP]

please make more videos on pandas

[@digambar6191]

Thank you sir

[@apna9656]

Hi Ankit In the interview they asked one question they provided me below table Name. month. Revenue (col name) Adi. Jab. 1000 Adi. Feb. 2000 Jack. Mar. 3000 They want an answer in below format Name. Jab_rev. Feb_rev. Mar_rev How can we do this? Please let us know

[@ankitbansal6]

kzbin.info/www/bejne/hWfQdZeLfturb80

[@sachintyagi2003]

thnks sir

[@Daughteroffice]

Thank you

[@sahil478]

Kaafi bekaar and confusing