Python Pandas: Select, SLICE & FILTER Data rows & columns by Index or Conditionals

This Python Pandas tutorial video teaches you how to select, slice and filter data in a DataFrame, by both rows and columns, using the index or conditionals such as Lambda functions. It explains head, tail, loc, iloc, and query functions, and covers numerical, string, and time series indexed data.
1:06 head, tail
2:52 selecting rows with loc
5:34 selecting columns
8:19 filtering with loc
10:16 lambda filter
11:25 iloc
16:00 df.query
20:19 Time Series
RELATED VIDEOS
► Numpy Intro: • Python: NUMPY | Numeri...
► Numpy Intro Jupyter nb: • NUMPY Arrays Tutorial ...
► Pandas Intro: • Python: Pandas Tutoria...
► Pandas Import Data: • Python Pandas - How to...
► Pandas Selecting & Filtering: • Python Pandas: Select,...
► Pandas Time Series: • Python Pandas - Workin...
► Pandas and MatPlotLib: • Python Pandas: Plottin...
► Matplotlib Intro: • Python: Intro to Visua...
Code: bit.ly/Pandas-nb
Twitter: / joejamesusa
Subscribe: bit.ly/like-th...
Thank me on Patreon: / joeyajames
#Python #Pandas

[@tafimadzi9118]

Beautifully explained! Thank you Joe.

[@MrRezashokouhi]

You helped me too man! Thank you very much!

[@lakshmichaitanya3411]

Thank you for making this video

[@liaojuoyu6244]

I usually don't leave comments, but I really love the way you explain this panda series! (especially when digging into python assignment ;P Thank you Joe

[@fatihakkentli8034]

it is so beneficial, well explained, thank you

[@leica0000]

I love your videos. You are really excellent at explaining things and I've been learning so much by watching them. Thank you for doing these.

[@alabtv4879]

you really explained well! I like it simple , clear, concise and easy to follow.

[@diazjubairy1729]

this video is very helpful, thank you

[@maxbart1353]

thanks for your explanations and sharing your knowledge :-)

[@leica0000]

Is there a Jupyter Notebook of this? I couldn't find one with this name on your Github

[@zeppelin1qaz]

Joe you can explain coding concepts than anyone I have seen. It's so much leaner and clearer. than others, no waffle. Can you do videos on 'Groupby' and 'Merge' two confusing, but essential and powerful methods in Pandas? Thank you!

[@oggiai]

Sure. Thanks

[@tinabeigi2493]

Hi, Thank you for the very clear video. Question: how do I select the rows and columns from one label to another label?

[@jdworkz]

7:30

[@gur0004]

hey Joe James, thank u so much for this pandas series. One of the best on KZbin. However, I tried filtering the time series the way u did in the video but got no output then used df.loc and got same output as u! why? I am using Pycharm if that makes a difference.

[@nervoustalk2885]

21:54 df1['2004'] not working for me, i have to change it into df1[df1.index.year == 2004]

[@ishikaishu2547]

Your video are so ossum... I am from India and watching thiS