python通过pandas来使mysql中2张表合并

背景:调用360点睛平台api接口 获取2个api返回的数据分别保存到表A 表B,将B表中的数据通过其字段keywordId来插入到A表，最终整合为一张表。

//B表中keywodrId会存在重复，需要去重
//page_page为页数计数器，api接口每次只能返回1页数据


import requests
import re
import pymysql
import pandas as pd
import json

def get_type():
    re1 = r'<type>([\s\S]*?)</type>'
    reg1 = re.compile(re1)
    str = reg1.findall(rece1)
    return str

def get_date():
    re1 = r'<date>([\s\S]*?)</date>'
    reg1 = re.compile(re1)
    str = reg1.findall(rece1)
    return str

def get_keywordId():
    re1 = r'<keywordId>([\s\S]*?)</keywordId>'
    reg1 = re.compile(re1)
    str = reg1.findall(rece1)
    return str

def get_keyword():
    re1 = r'<keyword>([\s\S]*?)</keyword>'
    reg1 = re.compile(re1)
    str = reg1.findall(rece1)
    return str

def get_groupId():
    re1 = r'<groupId>([\s\S]*?)</groupId>'
    reg1 = re.compile(re1)
    str = reg1.findall(rece1)
    return str

def get_campaignId():
    re1 = r'<campaignId>([\s\S]*?)</campaignId>'
    reg1 = re.compile(re1)
    str = reg1.findall(rece1)
    return str

def get_groupName():
    re1 = r'<groupName>([\s\S]*?)</groupName>'
    reg1 = re.compile(re1)
    str = reg1.findall(rece1)
    return str

def get_campaignName():
    re1 = r'<campaignName>([\s\S]*?)</campaignName>'
    reg1 = re.compile(re1)
    str = reg1.findall(rece1)
    return str

def get_views():
    re1 = r'<views>([\s\S]*?)</views>'
    reg1 = re.compile(re1)
    str = reg1.findall(rece1)
    return str

def