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

  Рет қаралды 4,622

Ankit Bansal

Ankit Bansal

Күн бұрын

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":["ankit@gmail.com","rahul@gmail.com","priya@gmail.com","neeta@gmail.com"] }
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

Пікірлер: 11
@zulfiquarshaikh3461
@zulfiquarshaikh3461 7 ай бұрын
superb explanation crisp and clear. Thank you Ankit !
@as-youtuber6215
@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
@ankitbansal6 Жыл бұрын
Sure will do
@sahilsood2028
@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 🙂
@sahil478
@sahil478 5 ай бұрын
Kaafi bekaar and confusing
@digambar6191
@digambar6191 3 ай бұрын
Thank you sir
@sachintyagi2003
@sachintyagi2003 Ай бұрын
thnks sir
@apna9656
@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
@ankitbansal6 Жыл бұрын
kzbin.info/www/bejne/hWfQdZeLfturb80
@UPESUBHADEEP
@UPESUBHADEEP Жыл бұрын
please make more videos on pandas
@Daughteroffice
@Daughteroffice 10 ай бұрын
Thank you
How do I select multiple rows and columns from a pandas DataFrame?
21:47
БЕЛКА СЬЕЛА КОТЕНКА?#cat
00:13
Лайки Like
Рет қаралды 2,6 МЛН
UNDERSTANDING LOC[ ] & iLOC[ ] IN PANDAS
11:13
Sundeep Saradhi Kanthety
Рет қаралды 63 М.
Python Pandas Tutorial: Pandas iloc and loc #8
15:49
Programming Is Fun
Рет қаралды 10 М.
Python Pandas Lambda Function Tutorial With EXAMPLES
12:58
Ryan & Matt Data Science
Рет қаралды 4,7 М.
PayPal SQL Interview Problem (Level Hard) | Advanced SQL Problem
14:15
Pandas Functions: Apply vs. Map vs. Applymap
11:53
Mısra Turp
Рет қаралды 26 М.
БЕЛКА СЬЕЛА КОТЕНКА?#cat
00:13
Лайки Like
Рет қаралды 2,6 МЛН