scala提取字符串中数字
The "calendar" class handles working with date and time in Scala, the class generates the current time in the following format,
 “ calendar”类处理Scala中的日期和时间 ，该类以以下格式生成当前时间， 
    Thu Apr 23 06:10:37 GMT 2020

We can extract different parts like date, month, and year.
 我们可以提取日期，月份和年份等不同部分。 
 计划在Scala中获取日期 (Program to get date in Scala)
import java.util.Calendar
import java.text.SimpleDateFormat

object MyClass {
    def main(args: Array[String]) {
        val cal = Calendar.getInstance
        val dateTime = cal.getTime
        
        println("Full date information : " + dateTime)
        
        val dateFormat = new SimpleDateFormat("dd")
        val date = dateFormat.format(dateTime)
        println("Date is : " + date)
        
        val dateFormat2 = new SimpleDateFormat("MMM")
        val month = dateFormat2.format(dateTime)
        println("Month is : " + month)
        
        val dateFormat3 = new SimpleDateFormat("YYYY")
        val year = dateFormat3.format(dateTime)
        println("Year is : " + year)
    }
}

Output
 输出量 
Full date information : Fri Apr 24 16:59:22 GMT 2020
Date is : 24
Month is : Apr
Year is : 2020

 提取月份号 (Extracting month number)
In Scala, we can extract the string in the form of the number instead of a string. The date format provides an option for this too. 
 在Scala中，我们可以提取数字形式的字符串而不是字符串。 日期格式也为此提供了一个选项。 
The format "MM" does our work.
 格式“ MM”完成了我们的工作。 
 程序将月份提取为数字 (Program to extract month as a number)
import java.util.Calendar
import java.text.SimpleDateFormat

object MyClass {
    def main(args: Array[String]) {
        val cal = Calendar.getInstance
        val dateTime = cal.getTime
        
        val dateFormat = new SimpleDateFormat("MM")
        val month = dateFormat.format(dateTime)
        
        println("Month number is : " + month)
    }
}

Output
 输出量 
Month number is : 04

 格式化月份字符串 (Formatting month string)
We can use string formatting methods like toUpperCase and toLowerCase to extract month as an uppercase string or lowercase string.
 我们可以使用诸如toUpperCase和toLowerCase之类的字符串格式化方法来将month提取为大写或小写字符串。 
Program:
 程序： 
import java.util.Calendar
import java.text.SimpleDateFormat

object MyClass {
    def main(args: Array[String]) {
        val cal = Calendar.getInstance
        val dateTime = cal.getTime
        
        val dateFormat = new SimpleDateFormat("MMM")
        val month = dateFormat.format(dateTime).toUpperCase
        println("Month is : " + month)
        
        val Lmonth = dateFormat.format(dateTime).toLowerCase
        println("Month is : " + Lmonth)
    }
}

Output
 输出量 
Month is : APR
Month is : apr


翻译自: https://www.includehelp.com/scala/how-to-get-date-month-and-year-as-string-or-number-in-scala.aspx
scala提取字符串中数字

# -*- 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)

将B列的日期格式转换为中文格式的月份。




出生日期
月份1
月份2




35927
=TEXT(A2,"[DBnum1]m月")
=TEXT(A2,“m月”)


B2单元格输入以下公式，向下复制。
=TEXT(A2,"[DBnum1]m月") 

C2单元格输入以下公式，向下复制。
 =TEXT(A2,"m月") 

格式代码“m”用于提取A2单元格中的月份，再使用格式代码[DBnum1]将其转换为中文小写数字格式。

在美国，2017 年圣诞节的表示是“12/25/17”，而在欧洲，同一个日子却表示为“25/12/17”。这里构造的日期和时间提取器尝试适配上面两种日/月的表示顺序，并检查以确保是有效的日期
import re
from datetime import date
import datetime

# 美国日期的正则表达式
us = r'((([01]?\d)[-/]([0123]?\d))([-/]([0123]\d)\d\d)?)'
mdy = re.findall(us, 'Santa came 12/25/2017. An elf appeared 12/12.')
print(mdy)

# 结构化提取的日期
# lstrip() 方法用于截掉字符串左边的空格或指定字符
dates = [{'mdy': x[0], 'md': x[1], 'm': int(x[2]), 'd': int(x[3]),
             'y': int(x[4].lstrip('/') or 0), 'c': int(x[5] or 0)} for x in mdy]
print(dates)

# 基本的上下文管理
# 使用在内存的结构化数据的上下文中最近读取到的年份来
# 填充任何缺失的数字字段
for i, d in enumerate(dates):
    for k, v in d.items():
        if not v:
            d[k] = dates[max(i - 1, 0)][k]

print(dates)
datetimes = [date(d['y'], d['m'], d['d']) for d in dates]
print(datetimes)


# 欧洲日期的正则表达式
eu = r'((([0123]?\d)[-/]([01]?\d))([-/]([0123]\d)?\d\d)?)'
dmy = re.findall(eu, 'Alan Mathison Turing OBE FRS (23/6/1912-7/6/1954) was an English computer scientist.')
print(dmy)
dmy = re.findall(eu, 'Alan Mathison Turing OBE FRS (23/6/12-7/6/54) was an English computer scientist.')
print(dmy)

# 综合提取
# 识别年份
# 两位数表示的年份，30-99 = 1930-1999
yr_19xx = (r'\b(?P<yr_19xx>' +
           '|'.join('{}'.format(i) for i in range(30, 100)) +
           r')\b')
# 一位或者两位数表示的年份，01-30 = 2001-2030
# 02d 格式一个整数（ d ）到最小宽度2（ 2 ）的字段，左侧填充零（前导 0 ）
yr_20xx = (r'\b(?P<yr_20xx>' +
           '|'.join('{:02d}'.format(i) for i in range(10)) + '|' +
           '|'.join('{}'.format(i) for i in range(10, 30)) +
           r')\b')
# 3 位数或者 4 位数表示的年份的前几位数字，如“123 A.D.”中的“1”
# 或者“2018”中的“20”
yr_cent = r'\b(?P<yr_cent>' + '|'.join('{}'.format(i) for i in range(1, 40)) + r')'
# 位数或者 4 位数表示的年份的后两位数字，如“123 A.D.”中的“23”
# 或者“2018”中的“18”
yr_ccxx = r'(?P<yr_ccxx>' + '|'.join('{:02d}'.format(i) for i in range(0, 100)) + r')\b'
yr_xxxx = r'\b(?P<yr_xxxx>(' + yr_cent + ')(' + yr_ccxx + r'))\b'
yr = (r'\b(?P<yr>' +
      yr_19xx + '|' + yr_20xx + '|' + yr_xxxx +
      r')\b')
# finditer()函数实现每次只返回一个，并且返回所在的位置
groups = list(re.finditer(yr, "0, 17, 2000, 01, '08, 99, 1984, 2030/1970 85 47 `66"))
full_years = [g['yr'] for g in groups]
print(full_years)

# 用正则表达式识别月份名称
mon_words = 'January February March April May June July August September October November December'
mon = (r'\b(?P<mon>' + '|'.join('{}|{}|{}|{}|{:02d}'.format(m, m[:4], m[:3], i + 1, i + 1) for i, m in enumerate(mon_words.split())) + r')\b')
print(re.findall(mon, 'January has 31 days, February the 2nd month of 12, has 28, except in a Leap Year.'))

# 组合信息提取正则表达式
day = r'(?P<day>' + '|'.join('{:02d}|{}'.format(i, i) for i in range(1, 32)) + r')\b'
eu = (r'\b(' + day.replace('<day', '<eu_day') + r')\b[-,/ ]{0,2}\b(' + mon.replace('<mon', '<eu_mon') + r')\b[-,/ ]{0,2}\b(' + yr.replace('<yr', '<eu_yr') + r')\b')
us = (r'\b(' + mon.replace('<mon', '<us_mon') + r')\b[-,/ ]{0,2}\b(' + day.replace('<day', '<us_day') + r')\b[-,/ ]{0,2}\b(' + yr.replace('<yr', '<us_yr') + r')\b')
date_pattern = r'\b(' + eu + '|' + us + r')\b'
print(list(re.finditer(date_pattern, '31 Oct, 1970 25/12/2017')))

# 验证日期
dates = []
es_groups = list(re.finditer(date_pattern, "0, 12/25/2017, 2000, 01, '08, 99, 1984, 31/10/1970, 85 47 `66"))
for g in es_groups:
    month_num = (g['us_mon'] or g['eu_mon']).strip()
    try:
        month_num = int(month_num)
    except ValueError:
        month_num = [w[:len(month_num)] for w in mon_words].index(month_num) + 1
    date = datetime.date(int(g['us_yr'] or g['eu_yr']), month_num, int(g['us_day'] or g['eu_day']))
    dates.append(date)
print("dates:", dates)