比较两个csv并合并它们

亚什·库马尔·阿特里

我需要使用 Python 和 Angular JS 将 CSV 文件从 python 发送到网页并相应地显示它。

我有 2 个带有字段的 CSV 文件

CSV1

Country code,Telecom,Latency

919618, India Private Mobile,0.008800

919619, India Private Mobile,0.008800

919620, India Private Mobile,0.008800

CSV2

Country code,Telecom,Latency

919802, India Private Mobile,0.008400

919803, India Private Mobile,0.008400

919620, India Private Mobile,0.008400

网页应显示为

Country code,Telecom,Latency

919618, India Private Mobile,0.008800

919619, India Private Mobile,0.008800

919802, India Private Mobile,0.008400

919803, India Private Mobile,0.008400

919620,India Private Mobile,0.008400,0.008800

（最后一行包含两个值，因为 CSV 文件中包含 919620 个公共点）

所以现在我是 Angular JS 和 Flask 的新手，请指导我如何开始？

从这个开始

import pandas as pd
import numpy as np


dfa = pd.read_csv('rate4.csv', names=['Country Code', 'SP', 'Rate']);
dfb = pd.read_csv('rate3.csv', names=['Country Code', 'SP', 'Rate']);

耶斯列

您可以使用输出DataFrame使用concat和groupby按列Country code和Telecom与join柱Latency：

df = pd.concat([df1, df2]) \
       .groupby(['Country code','Telecom'])['Latency'] \
       .apply(lambda x: ','.join(x.astype(str))) \
       .reset_index()
print (df)
   Country code               Telecom        Latency
0        919618  India Private Mobile         0.0088
1        919619  India Private Mobile         0.0088
2        919620  India Private Mobile  0.0088,0.0084
3        919802  India Private Mobile         0.0084
4        919803  India Private Mobile         0.0084

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。