<p>您可以用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.merge.html" rel="nofollow noreferrer">^{<cd1>}</a>和<code>indicator=True</code>和<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.query.html" rel="nofollow noreferrer">^{<cd3>}</a>来尝试<code>both</code>：</p>
<pre><code>matching_cols=df1.columns.intersection(df2.columns).tolist() #find matching columns to merge
df1.merge(df2,on=matching_cols,how='outer',indicator=True).query("_merge!='both'")
</code></pre>
<p>这将显示数据帧之间的不常见数据</p>
<hr/>
<pre><code> Hypervisor IP Operating System \
0 lglac125.lss.emc.com 10.247.52.125 VMware ESXi 5.5.0 build-9919047
5 lglac125.lss.emc.com VMware ESXi 5.5.0 build-9919047
6 DummyRow 10.247.52.129 VMware ESXi 5.5.0 build-9919047
Domain Memory No. CPU Availability (%) Last Collection Time \
0 lss.emc.com 524278.03125 4.0 100.0 1.558599e+09
5 lss.emc.com 524278.03125 4.0 100.0 1.558599e+09
6 lss.emc.com 524278.03125 4.0 100.0 1.558600e+09
Arrays DummyColumn _merge
0 NaN NaN left_only
5 NaN A right_only
6 NaN F right_only
</code></pre>
如何在python/pandas中比较两个csv文件（csv1和csv2）列中的所有条目？
回答此问题可获得 20 贡献值，回答如果被采纳可获得 50 分。
<p>我有2个CSV文件：</p>
<p>CSV1版本：</p>
<pre><code>"Hypervisor","IP","ABCD","Operating System","Domain","Memory","No. CPU","Availability (%)","Last Collection Time","lol"
"lglac125.lss.com","10.247.52.125","VMware ESXi 5.5.0 build-9919047","lss.com","524278.03125","4.0","100.0","1.558599031E9"
"lglac126.lss.com","10.247.52.126","VMware ESXi 5.5.0 build-9919047","lss.com","524278.03125","4.0","100.0","1.558599931E9"
"lglac127.lss.com","10.247.52.127","VMware ESXi 5.5.0 build-9919047","lss.com","524278.03125","4.0","0.0","1.558599031E9"
"lglac128.lss.com","10.247.52.128","VMware ESXi 5.5.0 build-9919047","lss.com","524278.03125","4.0","100.0","1.558599931E9"
"lglac129.lss.com","10.247.52.129","VMware ESXi 5.5.0 build-9919047","lss.com","524278.03125","4.0","100.0","1.558599931E9"
</code></pre>
<p>第2版：</p>
<pre><code>"Hypervisor","IP","Arrays","Operating System","Domain","Memory","No. CPU","Availability (%)","Last Collection Time","DummyColumn"
"lglac125.lss.com","10.247.52.125",,"VMware ESXi 5.5.0 build-9919047","lss.com","524278.03125","4.0","100.0","1.558599031E9","A"
"lglac126.lss.com","10.247.52.126",,"VMware ESXi 5.5.0 build-9919047","lss.com","524278.03125","4.0","100.0","1.558599931E9","B"
"lglac127.lss.com","10.247.52.127",,"VMware ESXi 5.5.0 build-9919047","lss.com","524278.03125","4.0","0.0","1.558599031E9","C"
"lglac128.lss.com","10.247.52.128",,"VMware ESXi 5.5.0 build-9919047","lss.com","524278.03125","4.0","100.0","1.558599931E9","D"
"lglac129.lss.com","10.247.52.129",,"VMware ESXi 5.5.0 build-9919047","lss.com","524278.03125","4.0","100.0","1.558599931E9","E"
"DummyRow","10.247.52.129",,"VMware ESXi 5.5.0 build-9919047","lss.com","524278.03125","4.0","100.0","1.558599931E9","F"
</code></pre>
<p>我试图将每列的所有条目（如果在csv2中可用）与相应的行进行比较。如果有任何条目丢失或更改，我需要升起一个标志。<strong>这两个文件中都有可能添加或删除任何列。</strong>因此我需要首先检查csv2中是否有x列，然后匹配csv1中相同列的条目。你知道吗</p>
<p>我已经为此挣扎了三天，但还是没有找到解决办法。我非常感谢你的帮助。你知道吗</p>
请先 登录 后评论
针对此问题: 更多的回答
- 89 关注
- 1 收藏，216 浏览
- 网友 提问于 2天前
相关Python问题
- Django:。是不是“超级用户”字段不起作用 9 回答
- Django:'DeleteQuery'对象没有属性'add' 8 回答
- Django:'ModelForm'对象没有属性 2 回答
- Django:'python manage.py runserver'返回'TypeError:'WindowsPath'类型的对象没有len（） 1 回答
- Django:'Python管理.pysyncdb'不创建我的架构表 8 回答
- Django:'Python管理.py迁移“耗时数小时（和其他奇怪的行为） 10 回答
- Django:'readonly'属性在我的ModelForm上不起作用 9 回答
- Django:'RegisterEmployeeView'对象没有属性'object' 5 回答
- Django:'str'对象没有属性'get' 9 回答
- Django：'创建' 不能被指定为Order模型表单中的值，因为它是一个不可编辑的字段 7 回答
- Django:“'QuerySet'类型的对象不是JSON可序列化的” 8 回答
- Django:“'utf8'编解码器无法解码位置19983中的字节0xe9：无效的连续字节”，加载临时文件时 5 回答
- Django:“<…>”需要有一个字段“id”的值，然后才能使用这个manytomy关系 7 回答
- Django:“AnonymousUser”对象没有“get_full_name”属性 5 回答
- Django:“ascii”编解码器无法解码位置1035中的字节0xc3：序号不在范围内（128） 3 回答
- Django:“BaseTable”对象不支持索引 5 回答
- Django:“collections.OrderedDict”对象不可调用 4 回答
- Django:“Country”对象没有属性“all” 9 回答
- Django:“Data”对象没有属性“save” 10 回答
- Django:“datetime”类型的对象不是JSON serializab 5 回答
