时间戳

首页 > 解决方案 > 在条件下删除DataFrame中的元素

python-3.x - 在条件下删除DataFrame中的元素

问题描述

我的 DataFrame 正在查看：

indeed.fr
11.41%
career2.successfactors.eu
8.53%
37.16%
pracuj.pl
7.40%
80.42%
corporate.danone.com.br
6.64%
indeed.com.br
4.68%
61.73%

因此，我只想保存第一个 % 如下：

indeed.fr
11.41%
career2.successfactors.eu
8.53%
pracuj.pl
7.40%
corporate.danone.com.br
6.64%
indeed.com.br
4.68%

所有行都是字符串等等我不知道我们是否可以在前一行包含 % 的条件下删除行？

有任何想法吗 ？

谢谢你的时间 ！

mydata =['indeed.fr','11.41%','career2.successfactors.eu','8.53%','37.16%','pracuj.pl','7.40%','80.42%','corporate.danone.com.br','6.64%','indeed.com.br','4.68%','61.73%']
df=pd.DataFrame(mydata)

最后，我想要这个：我的需要

标签： python-3.xpandasdataframeconditional

解决方案

mydata =['indeed.fr','11.41%','career2.successfactors.eu','8.53%','37.16%','pracuj.pl','7.40%','80.42%','corporate.danone.com.br','6.64%','indeed.com.br','4.68%','61.73%']

df = pd.DataFrame(mydata)

是您创建的样本。

解决方案如下

rowList = []
row = []

#Variable to keep track of the number of times I see the percentage value
percentVal = 0

for i in df.index:


    if(df.at[i, 0][0] not in set('0123456789')):


        row.append(df.at[i, 0])

        percentVal = 0

    else:


        percentVal += 1

        if(percentVal != 2):
            row.append(df.at[i, 0])
            rowList.append(row)
            row = []

        else:
            #If percentVal == 2, that means, I have seen my second percentage value and I'm going to skip it.
            print("Skipping {}".format(df.at[i, 0]))
            row = []



yourSol = pd.DataFrame(rowList)
yourSol.columns = ['Incoming Referal Sources', 'Value (%)']

print(yourSol)

推荐阅读