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

preview_player
Показать описание
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
df = pd.DataFrame(emp)

Zero to hero(Advance) SQL Aggregation:

Most Asked Join Based Interview Question:

Solving 4 Trick SQL problems:

Data Analyst Spotify Case Study:

Top 10 SQL interview Questions:

Interview Question based on FULL OUTER JOIN:

Playlist to master SQL :

Rank, Dense_Rank and Row_Number:

#python #pandas #analytics
Рекомендации по теме
Комментарии
Автор

superb explanation crisp and clear. Thank you Ankit !

zulfiquarshaikh
Автор

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 🙂

sahilsood
Автор

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

as-youtuber
Автор

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

apna