在Pandas中找到一个空值并从dataframe中删除

Question

嗨，我有一个500+行的数据帧。在

    company_url company tag_line    product data
0   https://angel.co/billguard  BillGuard   The fastest smartest way to track your spendin...   BillGuard is a personal finance security app t...   New York City · Financial Services · Security ...
1   https://angel.co/tradesparq Tradesparq  The world's largest social network for global ...   Tradesparq is Alibaba.com meets LinkedIn. Trad...   Shanghai · B2B · Marketplaces · Big Data · Soc...
2   https://angel.co/sidewalk   Sidewalk    Hoovers (D&B) for the social era    Sidewalk helps companies close more sales to s...   New York City · Lead Generation · Big Data · S...
3   https://angel.co/pangia Pangia  The Internet of Things Platform: Big data mana...   We collect and manage data from sensors embedd...   San Francisco · SaaS · Clean Technology · Big ...
4   https://angel.co/thinknum   Thinknum    Financial Data Analysis Thinknum is a powerful web platform to value c...   New York City · Enterprise Software · Financia...

我想做的是在“data”列中找到null并从dataframe中删除行。我为它编写了代码，但我相信它没有像预期的那样工作，因为行数没有改变。有人能帮我吗？在

我的代码：

^{pr2}$

Answer 1

使用布尔掩码只能保留notnull值：

df = df[df["data"].notnull()]

Answer 2

试试看

bigdata_filtered = bigdata_comp_dropped[~bigdata_comp_dropped['data'].isnull()]