pandas-按照位数补0，时间转换日期，正则提取数字

# -*- coding: utf-8 -*-
"""
Created on Thu Feb 20 22:14:22 2020

@author: zyxxs
"""

import pandas as pd 
import numpy as np
import time

dfrl['agent_code']=dfrl['AGENT_CODE'].apply(lambda x:str(x).zfill(11))

dfrl['agent_code']=dfrl['AGENT_CODE'].astype(str).str.zfill(11)



df_sort['date']=pd.to_datetime(df_sort['提交答卷时间']).apply(lambda x:x.strftime('%Y-%m-%d'))



df_unique['agent_code']=df_unique['1、请输入参会人员姓名或代码：'].str.extract(r'(\d+)', expand=False)