#!/usr/bin/env python
# -*- coding: utf-8 -*-
import sys
import operator
import json
import collections
import operator
import pandas as pd
from datetime import datetime, date, timedelta
from time import strftime, localtime
import calendar
from dateutil.relativedelta import relativedelta
df1 = pd.DataFrame([['Snow', 'M', 22], ['Tyrion', 'M', 32], ['Sansa', 'F', 18], ['Arya', 'F', 14]])
print pd.concat([df1, None])
df = pd.DataFrame(columns=('lib', 'qty1', 'qty2'))
print df
df = pd.DataFrame([['None', 'None', 'subway', 'None', 'None', 'None']])
print df
# 获取周几
week = datetime.strptime('20200505', "%Y%m%d").weekday()
print week
# 获取前两天前日期
yesterday = datetime.strptime('2020-05-05', "%Y-%m-%d") + timedelta(days=-2)
print yesterday.strftime("%Y%m%d")
# 获取六个月前日期
font_6_time = yesterday - relativedelta(months=6)
print font_6_time.strftime("%Y%m01")
a = [1, 2, 3, 4]
print a[0:4]
latest = "20200701"
yesterday = datetime.strptime('2020-05-01', "%Y-%m-%d") + timedelta(days=-1)
print yesterday.strftime("%Y%m01")
print (datetime.strptime(latest, '%Y%m%d') + timedelta(days=7)).strftime('%Y%m%d')
print (datetime.strptime(latest, '%Y%m%d') +relativedelta(months=-1)).strftime('%Y%m%d')
print (datetime.strptime(latest, '%Y%m%d') +timedelta(hours=7)).strftime('%Y%m%d')
print datetime.strptime('2020-05-05', "%Y-%m-%d").strftime("%Y%m01")
a = (datetime.strptime(datetime.strptime('2020-05-05', "%Y-%m-%d").strftime("%Y%m01"), "%Y%m%d") + timedelta(
days=-1)).strftime("%Y%m%d")
print a
print (datetime.strptime(datetime.strptime('2020-05-05', "%Y-%m-%d").strftime("%Y%m01"), "%Y%m%d") + timedelta(
days=-1)).strftime("%Y%m%d")
print int('-1')