How do I remove columns from a pandas DataFrame?

If you have DataFrame columns that you're never going to use, you may want to remove them entirely in order to focus on the columns that you do use. In this video, I'll show you how to remove columns (and rows), and will briefly explain the meaning of the "axis" and "inplace" parameters.

SUBSCRIBE to learn data science with Python:

JOIN the "Data School Insiders" community and receive exclusive rewards:

== RESOURCES ==

== LET'S CONNECT! ==

[erfannazari]

Amazing Teacher!
Every tutorial has something that i would do lots of searching to find it out!
Thank you Kevin!

[amandal]

You youtube always clear and with structures. This is is handy. Waiting you to have more videos - like data Wrangling + Modeling.

[solme]

This is the first video that I watch from u and 100% sure won't be the last. THANK U

[andrenevares]

Such a nice explanation. I think one of the best explanations on Youtube so far. Nice Job!

[revolutionN]

Thank you for all your efforts. Your videos are really organized and the material is thoroughly explained. It's very noble of you.

[sarikakazi]

Very well explained! The Data analysis in Python series is so useful!!!

[afrozaaktermousumi]

Sir, just excellent, we want your videos on pandas on more difficult topics

[myravat]

Thanks for posting the videos. Very easy to understand.Keep up the good work

[kennyl]

thanks a lot for this wonderful short video! very helpful!

[robertorolo]

Your classes are awesome! Thank you very much. It is veery useful.

[Nurlan_Turganov]

I am very glad that you made these videos! Thank you!

[rogersteven]

Sir Kevin Markham, this is indeed very helpful

[goldensleeves]

Love your videos! QUESTION: Do you have a video that explains when it's a good idea to drop certain columns? For example, how do we determine if a column should be dropped before using it as a feature to predict a target in machine learning problems? Which columns are worth keeping and which ones are "noisy" or unhelpful? Thanks so much for all you do in the world of teaching!

[dianavallejo]

you are the best explaining python!!!!

[sherlockom]

hey i got to know that we can also use :
del(ufo['City'])
for example, to remove city column.
this will work to delete a single column only.

[VishalSharma-rnmt]

Thanks buddy for this very clear video.

[mohnasnassr]

we can use also
ufo.drop(list(range(1, 5)), axis=0, inplace=True) to drop more rows

[anisity-nq]

I didn't quite understand what 'inplace=True' means from this video. But thanks anyways! I like this series a lot and will keep watching it.

[nzsdkbm]

thanks, when I study with this vedio I feel the time is slowly

[goodmorninghumans]

Good stuff! I do have a question, but I'm sure I can find the answer...it does seem to be a difficult one to hunt up though. I am importing data for use in training deep learning trading strategies, and the timestamp is in unix. I am having difficulty converting those into datetime. I am sure by the time you respond, if you do...I will have solved it, but it might make for a helpful tutorial, since I have seen I am not the only one with this difficulty. But, I would also like to say that this is an excellent series of tutorials. Very well done. You are a good instructor. Thanks for the great lessons! +