Pandas实现模糊匹配Merge数据的方法
import pandas as pd
import numpy as np
import re
1. 两份数据
df_keyword = pd.DataFrame({
"keyid": np.arange(5),
"keyword": ["numpy", "pandas", "matplotlib", "sklearn", "tensorflow"]
})
df_keyword
|
keyid |
keyword |
0 |
0 |
numpy |
1 |
1 |
pandas |
2 |
2 |
matplotlib |
3 |
3 |
sklearn |
4 |
4 |
tensorflow |
df_sentence = pd.DataFrame({
"senid": np.arange(10, 17),
"sentence": [
"怎样用Pandas实现数据的Merge?",
"Python之Numpy详细教程",
"怎样使用Pandas批量拆分与合并Excel文件?",
"怎样使用Pandas的map和apply函数?",
"深度学习及TensorFlow简介",
"Tensorflow和Numpy的关系",
"基于sklearn的一些机器学习的代码"
]
})
df_sentence