该博客介绍了如何使用pandas库在数据框中筛选出以'201'开头的列，即保留2010年及以后的数据。通过使用`df.filter(regex='^201')`，可以确保只选择以'201'开始的列，从而过滤掉不相关的时间段。
I have a dataframe like this
id 2013 Profits 2001 Revenues 1999 Assets...
31 xxxx xxxx xxxx
...
I want to drop the columns that do not start with '201' (I only want to keep the data 2010 and forward).
How can I do that?
解决方案df.filter(like='201')
2013 Profits
id
31 xxxx
As pointed out by @StevenLaan using like will include some columns that have the pattern string somewhere else in the columns name. We can ensure that we only get columns that begin with the pattern string by using regex instead.
df.filter(regex='^201')
2013 Profits
id
31 xxxx
扫一扫
975
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
