如何读取txt文件并与xlsx合并

Question

我有一个很大的myfile.txt文件（52375 kb，ln 86213，18），如下所示

E.g

myfile.txt

  "Name"     "ID"   "School"            .                 .
  "steven"  "1212"  "harvard"          .                 .
  "michael" "9898"  "stanford"         .                 . 
     .      .      .
     .      .      .



In [1]
df1 = pd.read_csv("myfile.txt", sep = "\t", lineterminator = "\n")

Out [1]
           Name     ID  School            .                 .
  steven  1212  harvard          .                 .
  michael 9898  stanford         .                 . 
     .      .      .
     .      .      .

但当我想和数据库.xlsx，它不起作用。它只显示合并后数据帧的标题

In [2]: df2 = pd.read_excel('Data Base Currency.xlsx')

Out [2]:
ID       status
1212     mechanical engineering
9898     electrical engineering

In [3]: df3 = pd.merge(df1,df2, on = "ID", how = "inner")

**and then my merge statement doesn't work**
Out [3]:
Name     ID  School   status

我的期望

  Name     ID                     School            .                 .
  steven  mechanical engineering  harvard          .                 .
  michael Electrical engineering  stanford         .                 . 
     .      .      .
     .      .      .

Answer 1

可能有不同数据类型的列。 试着运行这个并告诉他们什么是heppens：

df1["ID"] = df1["ID"].astype(int)
df2["ID"] = df2["ID"].astype(int)
df3 = pd.merge(df1,df2, on = "ID", how = "inner")