Python:从数据框中删除在字典中不存在其值的行 [英] Python: Deleting rows from dataframe for which value does not exist in dictionary

问题描述

我有一个csv文件(或数据框)，如下所示:

I have a csv file(or dataframe) like below :

Text    Location    State
A   Florida, USA    Florida
B   NY              New York
C       
D   abc 

还有一个键值对为的字典:

And a dictionary with key value pair as :

stat_map = {
        'FL': 'Florida',
        'NY': 'New York',
        'AR': 'Arkansas',
}

如何删除第3行和第4行，即使用Text C& D，以便我的数据框仅包含我在字典中具有价值的那些行.状态为空或具有某些不在词典值中的值的所有行均应删除.最终输出应如下所示:

How may I delete row 3rd and 4th i.e. row with Text C & D so that my dataframe contains only those rows for which i have value in dictionary. All rows for which state is either blank or has some value which is not in dictionary value should be deleted. The final output should look like :

Text    Location    State
    A   Florida, USA    Florida
    B   NY              New York

请帮助.

推荐答案

使用 查看全文