代码之家 › 专栏 › 技术社区 › Karn Kumar

如何用另一个dataframe熊猫替换dataframe的特定列

pandas python-3.x

Karn Kumar · 技术社区 · 6 年前

当我在玩一个excel数据集时,我给出了两个数据帧 data_xls 和 seggCol . 在哪里? DATAXXLS 有柱子 'Internal Link Tracking (non-promotions) - ENT (c20)' 我想把它替换成 塞格科 数据文件。

但是当你看东西的时候 df.join 或 df.concat 我真的不知道该怎么做。

说数据帧 DATAXXLS 的专栏 [Internal Link Tracking (non-promotions) - ENT (c20)] 将被另一个数据帧替换 塞格科 S柱 ['Internal Link Tracking', 'Campaign Name', 'Creative', 'Action', 'Action 2']

第一个数据帧:

数据帧列…

   >>> data_xls.columns
    Index(['Date', 'Internal Link Tracking (non-promotions) - ENT (c20)', 'BFY_LinkedIn_SponsoredContent_Visits', 'BFY_LinkedIn_inMail_Visits', 'BFY_DBM_Native_Visits',
           'BFY_SGCPB_Native_Visits', 'BFY_SGCBDC_Email_Visits', 'BFY_SGCPB_Email_Visit', 'BFY_SGCBDC_Native_Visits', 'BFY_ConstructionDive_Email_Visit',
           'BFY_ConstructionDive_PromotedStory_Visit', 'BFY_SGCPB_PromotedStory_Visit', 'BFY_SGCBDC_PromotedStory_Visit', 'BFY_ConstructionDive_Native_Visits'],
          dtype='object')

数据帧结构..

>>> data_xls.head()
        Date Internal Link Tracking (non-promotions) - ENT (c20)  BFY_LinkedIn_SponsoredContent_Visits  BFY_LinkedIn_inMail_Visits  BFY_DBM_Native_Visits  \
0 2018-08-20         us-campaign-article1-scrolldown-findoutnow                                      0                           0                      0
1 2018-08-20                   us-campaign-article1-scrollright                                      0                           0                      0
2 2018-08-20                    us-campaign-article1-findoutnow                                      1                           0                      1
3 2018-08-20          us-campaign-payablesmanagement-findoutnow                                      0                           0                      0
4 2018-08-20        us-campaign-strategicpurchasing-scrollright                                      0                           0                      0

   BFY_SGCPB_Native_Visits  BFY_SGCBDC_Email_Visits  BFY_SGCPB_Email_Visit  BFY_SGCBDC_Native_Visits  BFY_ConstructionDive_Email_Visit  \
0                        0                        0                      0                         0                                 0
1                        0                        0                      0                         0                                 0
2                        0                        0                      0                         0                                 0
3                        0                        0                      0                         0                                 0
4                        0                        0                      0                         0                                 0

   BFY_ConstructionDive_PromotedStory_Visit  BFY_SGCPB_PromotedStory_Visit  BFY_SGCBDC_PromotedStory_Visit  BFY_ConstructionDive_Native_Visits
0                                         0                              0                               0                                   0
1                                         0                              0                               0                                   0
2                                         0                              0                               0                                   0
3                                         0                              0                               0                                   0
4                                         0                              0                               0                                   0

第二个数据帧:

数据帧列…

   >>> seggCol.columns
        Index(['Internal Link Tracking', 'Campaign Name', 'Creative', 'Action', 'Action 2'], dtype='object')

数据帧结构..

>>> seggCol.head()
  Internal Link Tracking Campaign Name             Creative       Action    Action 2
0                     us      campaign             article1   scrolldown  findoutnow
1                     us      campaign             article1  scrollright        None
2                     us      campaign             article1   findoutnow        None
3                     us      campaign   payablesmanagement   findoutnow        None
4                     us      campaign  strategicpurchasing  scrollright        None

所需的新数据帧:

           Date Internal Link Tracking     Campaign Name             Creative       Action              Action 2  BFY_LinkedIn_SponsoredContent_Visits  BFY_LinkedIn_inMail_Visits  BFY_DBM_Native_Visits  \
0    2018-08-20                          us      campaign             article1   scrolldown            findoutnow                                     0                           0                      0
23   2018-08-20                          us      campaign             article1    learnmore   strategicpurchasing                                     0                           0                      0
24   2018-08-20                          us      campaign             article1    learnmore  controlandvisibility                                     0                           0                      0
25   2018-08-21                          us      campaign             article1   scrolldown            findoutnow                                     0                           0                      0
26   2018-08-21                          us      campaign             article1  scrollright                  None                                     0                           0                      0
27   2018-08-21                          us      campaign             article1   findoutnow                  None                                     1                           1                      0
28   2018-08-21                          us      campaign   payablesmanagement   findoutnow                  None                                     2                           1                      0
29   2018-08-21                          us      campaign  strategicpurchasing  scrollright                  None                                     3                           2                      1

2 回复 | 直到 6 年前

srikavineehari 6 年前

试试这个。将列名替换为您的列名:

df1 = pd.DataFrame({'col1': [1, 2, 3], 'col2': [4, 5, 6]})
df2 = pd.DataFrame({'col3': [1, 2, 3], 'col4': [4, 5, 6]})
final_df = pd.concat([df1['col1'], df2, df1['col2']], axis=1)
final_df

编辑 :或者,可以对列进行切片并获得所需的输出。用您的变量名替换我的变量名:

final_df = pd.concat([df1.iloc[:,0:1], df2, df1.iloc[:,1:]], axis=1)

Malik Asad 6 年前

试试这个

concatenation = [data_xls, seggCol]
 result = pd.concat(concatenation)

如果要用seggcol[“内部链接跟踪”(internal link tracking)(非促销)-ent(c20)']替换值data_xls[“内部链接跟踪”(internal link tracking)]

不需要加入或连接。