Python两个表合并返回空的数据框

Question

我对Python和Stackoverflow都是新手，如果我忽略了什么，请接受我的道歉。你知道吗

我只是想合并两个表。你知道吗

表1：非国有企业

<class 'pandas.core.frame.DataFrame'>
Int64Index: 48 entries, 0 to 47
Data columns (total 2 columns):
State    48 non-null object
Mean     48 non-null float64
dtypes: float64(1), object(1)
memory usage: 1.1+ KB

    State       Mean
0   Alabama     51912.500000
1   Arizona     56918.401961
2   Arkansas    56431.216216
3   California  73346.414226
4   Colorado    70932.230769

表2：生活成本

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 50 entries, 0 to 49
Data columns (total 2 columns):
State             50 non-null object
Cost of living    50 non-null object
dtypes: object(2)
memory usage: 880.0+ bytes

    State       Cost of living
0   Alabama     46,055
1   Alaska      53,070
2   Arizona     43,278
3   Arkansas    46,672
4   California  51,386

代码如下：

netIncome = costOfLiving.merge(right=incomeStates, on="State", validate="1:m")

但是，我得到了一个非常令人失望的结果，合并表返回空值，只有标题。你知道吗

<class 'pandas.core.frame.DataFrame'>
Index: 0 entries
Data columns (total 3 columns):
State             0 non-null object
Cost of living    0 non-null object
Mean              0 non-null float64
dtypes: float64(1), object(2)
memory usage: 0.0+ bytes

State   Cost of living  Mean

期望的结果是所有州的生活方式和成本的各自价值的数据框架。类似于此：

    State       Mean       Cost of living
0   Alabama     51912.500000   46,055
1   Alaska      NaN            53,070
2   Arizona     56918.401961   43,278
3   Arkansas    56431.216216   46,672
4   California  73346.414226   51,386
5   Colorado    70932.230769  

你有没有建议我做错了什么？你知道吗

谢谢你们。你知道吗