我试图通过数据帧的索引复制/复制数据帧中的几行,但我没有做出任何接近的结果。
给定此数据帧:
DataFrame示例
我的代码:
def duplicateDealers(self, data):
pd.options.display.width = 0
counter = 0
for index, row in data.iterrows():
brandColumn = 'Brand' + str(counter)
# print(index, row[brandColumn])
if str(row[brandColumn]) == 'Cadillac':
newData = pd.DataFrame(np.repeat(data.loc[int(index)], 1))
newData['Repeated'] = 'Yes'
print(newData.columns)
print(type(pd.DataFrame(np.repeat(data.loc[int(index)], 1))))
print(newData)
如果我使用以下代码:
newData = pd.DataFrame(np.repeat(data.loc[int(index)], 1, axis=0))
我得到这个错误:
ValueError:repeat((的panda实现中不支持"axis"参数
我想用这段代码实现什么?
我在行和列上迭代以识别单词";凯迪拉克;在列";Brand0";,如果条件为True,则我希望通过索引复制整行并保持该行的原始格式,然后我将根据需要操作新行数据。
输出如下(列名"4108"是一个随机索引,DataFrame有大量记录,超过5k(:
实际输出
我想要的输出是:
期望输出
我做错了什么?
致以问候和感谢。
编辑:
以下是一些示例数据:
Source_ID | SecondaryName | PrimaryName | Address | City | State | Full_Postal_Code | Postal_Code | Country | Telephone | Brand0
123456 | JACK SCHMITT CADILLAC, INC. | JACK SCHMITT CADILLAC, INC. | 915 W HWY 50 | O FALLON | IL | 62269 | 62269 | USA | 6186321001 | Cadillac
987654 | JAMES E. BLACK CADILLAC | JAMES E. BLACK CADILLAC | 3929 ADMIRAL PEARY HWY | EBENSBURG | PA | 15931 | 15931 | USA | 8144729553 | Cadillac
753951 | COLE-VALLEY MOTOR COMPANY | COLE-VALLEY MOTOR COMPANY | 4111 ELM ROAD NE | WARREN | OH | 44483 | 44483 | USA | 3303721668 | Cadillac
159357 | MCDONALD GMC-CADILLAC, INC. | MCDONALD GMC-CADILLAC, INC. | 5155 STATE ST | SAGINAW | MI | 48603 | 48603 | USA | 9897905154 | Cadillac
456987 | DAVID BRUCE AUTO CENTER, INC. | DAVID BRUCE AUTO CENTER, INC. | 555 LATHAM DR | BOURBONNAIS | IL | 60914 | 60914 | USA | 8159337709 | Cadillac
321456 | JACK WOLF CADILLAC-GMC TRUCK, INC. | JACK WOLF CADILLAC-GMC TRUCK, INC. | 1855 N STATE ST | BELVIDERE | IL | 61008 | 61008 | USA | 8155443403 | Cadillac
编辑2:
以下是我试图实现的目标的更多细节:
每一行可能有几个BrandX列,根据其内容,我会复制该行,并将品牌名称和其他内容添加到Source_ID中,这样我就可以根据经销商品牌拥有适当数量的记录。
DataFrame:
Source_ID | SecondaryName | PrimaryName | Address | City | State | Full_Postal_Code | Postal_Code | Country | Telephone | Brand0 | Brand1 | Brand2
123456 | JACK SCHMITT CADILLAC, INC. | JACK SCHMITT CADILLAC, INC. | 915 W HWY 50 | O FALLON | IL | 62269 | 62269 | USA | 6186321001 | Cadillac | GMC | Buick
987654 | JAMES E. BLACK CADILLAC | JAMES E. BLACK CADILLAC | 3929 ADMIRAL PEARY HWY | EBENSBURG | PA | 15931 | 15931 | USA | 8144729553 | Cadillac | NaN | GMC
753951 | COLE-VALLEY MOTOR COMPANY | COLE-VALLEY MOTOR COMPANY | 4111 ELM ROAD NE | WARREN | OH | 44483 | 44483 | USA | 3303721668 | Cadillac | Buick | NaN
159357 | MCDONALD GMC-CADILLAC, INC. | MCDONALD GMC-CADILLAC, INC. | 5155 STATE ST | SAGINAW | MI | 48603 | 48603 | USA | 9897905154 | Cadillac | Buick | NaN
456987 | DAVID BRUCE AUTO CENTER, INC. | DAVID BRUCE AUTO CENTER, INC. | 555 LATHAM DR | BOURBONNAIS | IL | 60914 | 60914 | USA | 8159337709 | Cadillac | Chevrolet | GMC
321456 | JACK WOLF CADILLAC-GMC TRUCK, INC. | JACK WOLF CADILLAC-GMC TRUCK, INC. | 1855 N STATE ST | BELVIDERE | IL | 61008 | 61008 | USA | 8155443403 | Cadillac | NaN | NaN
预期输出:
Source_ID | SecondaryName | PrimaryName | Address | City | State | Full_Postal_Code | Postal_Code | Country | Telephone | Brand0 | Brand1 | Brand2
123456_Cadillac | JACK SCHMITT CADILLAC, INC. | JACK SCHMITT CADILLAC, INC. | 915 W HWY 50 | O FALLON | IL | 62269 | 62269 | USA | 6186321001 | Cadillac | GMC | Buick
123456_GMC | JACK SCHMITT CADILLAC, INC. | JACK SCHMITT CADILLAC, INC. | 915 W HWY 50 | O FALLON | IL | 62269 | 62269 | USA | 6186321001 | Cadillac | GMC | Buick
123456_Buick | JACK SCHMITT CADILLAC, INC. | JACK SCHMITT CADILLAC, INC. | 915 W HWY 50 | O FALLON | IL | 62269 | 62269 | USA | 6186321001 | Cadillac | GMC | Buick
987654_Cadillac | JAMES E. BLACK CADILLAC | JAMES E. BLACK CADILLAC | 3929 ADMIRAL PEARY HWY | EBENSBURG | PA | 15931 | 15931 | USA | 8144729553 | Cadillac | NaN | GMC
987654_GMC | JAMES E. BLACK CADILLAC | JAMES E. BLACK CADILLAC | 3929 ADMIRAL PEARY HWY | EBENSBURG | PA | 15931 | 15931 | USA | 8144729553 | Cadillac | NaN | GMC
753951_Cadillac | COLE-VALLEY MOTOR COMPANY | COLE-VALLEY MOTOR COMPANY | 4111 ELM ROAD NE | WARREN | OH | 44483 | 44483 | USA | 3303721668 | Cadillac | Buick | NaN
753951_GMC | COLE-VALLEY MOTOR COMPANY | COLE-VALLEY MOTOR COMPANY | 4111 ELM ROAD NE | WARREN | OH | 44483 | 44483 | USA | 3303721668 | Cadillac | Buick | NaN
159357_Cadillac | MCDONALD GMC-CADILLAC, INC. | MCDONALD GMC-CADILLAC, INC. | 5155 STATE ST | SAGINAW | MI | 48603 | 48603 | USA | 9897905154 | Cadillac | Buick | NaN
159357_Buick | MCDONALD GMC-CADILLAC, INC. | MCDONALD GMC-CADILLAC, INC. | 5155 STATE ST | SAGINAW | MI | 48603 | 48603 | USA | 9897905154 | Cadillac | Buick | NaN
456987_Cadillac | DAVID BRUCE AUTO CENTER, INC. | DAVID BRUCE AUTO CENTER, INC. | 555 LATHAM DR | BOURBONNAIS | IL | 60914 | 60914 | USA | 8159337709 | Cadillac | Chevrolet | GMC
456987_Chevrolet | DAVID BRUCE AUTO CENTER, INC. | DAVID BRUCE AUTO CENTER, INC. | 555 LATHAM DR | BOURBONNAIS | IL | 60914 | 60914 | USA | 8159337709 | Cadillac | Chevrolet | GMC
456987_GMC | DAVID BRUCE AUTO CENTER, INC. | DAVID BRUCE AUTO CENTER, INC. | 555 LATHAM DR | BOURBONNAIS | IL | 60914 | 60914 | USA | 8159337709 | Cadillac | Chevrolet | GMC
321456_Cadillac | JACK WOLF CADILLAC-GMC TRUCK, INC. | JACK WOLF CADILLAC-GMC TRUCK, INC. | 1855 N STATE ST | BELVIDERE | IL | 61008 | 61008 | USA | 8155443403 | Cadillac | NaN | NaN
下面的方法可以做到这一点。
模块
import numpy as np
import pandas as pd
示例数据
df = pd.DataFrame({'Source':[111347,115742,100007], 'Brand0':['Cadillac', 'Cadillac', 'Alternative']})
使用np.repeat
的解决方案。
df.loc[np.repeat(df.index.values, list(df['Brand0'].isin(['Cadillac'])+1))]