[Tutor] Delete unwanted rows
Alexis Prime
ap235711 at gmail.com
Wed Apr 9 11:23:09 CEST 2014
Hello,
My question is whether I should write a loop or a function to delete rows.
I'm using pandas. But you may be able to help me as my question is about
the reasoning behind programming.
I have a pandas dataframe that looks like this, covering all countries in
the world, for over 200 rows and many columns:
Canada 20
China 112
Germany 10
Japan 12
Martinique 140
Mexico 180
Saint Kitts 90
Saint Martins 133
Saint Helena 166
USA 18
# So I write a list of small countries that I wish to exclude from my
analysis. What I want to do is to delete the rows from my dataframe.
toexclude = ['Martinique', 'Saint Kitts', 'Saint Martins', 'Saint
Helena']
After this, should I write a loop to loop through the dataframe, find the
countries that I want to delete, and then delete the rows?
Or should I write a function, which deletes those rows, and then returns me
a new and trimmed dataframe?
Thank you for helping me figure this out.
Alexis
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20140409/cde36dea/attachment.html>
More information about the Tutor
mailing list