251797_zh-CN

liliconcom

合并两列

我试图加入两个数据框，但无法理解Python必须提供的可能性。

第一个JMP数据文件：

<SPAN class="pln">ID MODEL   REQUESTS ORDERS</SPAN><SPAN class="lit">1</SPAN>  <SPAN class="typ">Golf</SPAN>    <SPAN class="lit">123</SPAN>      <SPAN class="lit">4</SPAN>
<SPAN class="lit">2</SPAN>  <SPAN class="typ">Passat</SPAN>  <SPAN class="lit">34</SPAN>       <SPAN class="lit">5</SPAN>
<SPAN class="lit">3</SPAN>  <SPAN class="typ">Model</SPAN> <SPAN class="lit">3</SPAN> <SPAN class="lit">500</SPAN>      <SPAN class="lit">8</SPAN>
<SPAN class="lit">4</SPAN><SPAN class="pln">  M3      </SPAN><SPAN class="lit">5</SPAN>        <SPAN class="lit">0</SPAN>

第二个JMP数据文件：

<SPAN class="pln">MODEL   TYPE  MAKE</SPAN><SPAN class="typ">Golf</SPAN>    <SPAN class="typ">Sedan</SPAN> <SPAN class="typ">Volkswagen</SPAN><SPAN class="pln">M3      </SPAN><SPAN class="typ">Coupe</SPAN><SPAN class="pln"> BMW</SPAN><SPAN class="typ">Model</SPAN> <SPAN class="lit">3</SPAN> <SPAN class="typ">Sedan</SPAN> <SPAN class="typ">Tesla</SPAN>

我想要的是在第一个数据帧中添加另一列称为“ make”，使其看起来像这样：

<SPAN class="pln">ID MODEL   MAKE       REQUESTS ORDERS</SPAN><SPAN class="lit">1</SPAN>  <SPAN class="typ">Golf</SPAN>    <SPAN class="typ">Volkswagen</SPAN> <SPAN class="lit">123</SPAN>      <SPAN class="lit">4</SPAN>
<SPAN class="lit">2</SPAN>  <SPAN class="typ">Passat</SPAN>  <SPAN class="typ">Volkswagen</SPAN> <SPAN class="lit">34</SPAN>       <SPAN class="lit">5</SPAN>
<SPAN class="lit">3</SPAN>  <SPAN class="typ">Model</SPAN> <SPAN class="lit">3</SPAN> <SPAN class="typ">Tesla</SPAN>      <SPAN class="lit">500</SPAN>      <SPAN class="lit">8</SPAN>
<SPAN class="lit">4</SPAN><SPAN class="pln">  M3      BMW        </SPAN><SPAN class="lit">5</SPAN>        <SPAN class="lit">0</SPAN>

 有什么建议我可以开始吗？

回复：合并两列

看来您需要菜单选项“ 表格>联接 '。您的帖子有点混乱，但是使用所附的表格并像这样设置对话框：

 

 

你应该靠近。你也可以看看虚拟联接 。