工作，python常用代码段

 1,读写excle

读excel
pandas.read_excel（io，sheet_name = 0，header = 0，names = None，index_col = None，usecols = None，squeeze = False,dtype = None, ...）

写excel
df.to_excel(r'D:\xxx\a.xlsx')
with pd.ExcelWriter(r'D:\xxx.xlsx') as writer:
    offline_score1.to_excel(writer,sheet_name='offline_score1',index=False)
    offline_score2.to_excel(writer,sheet_name='offline_score2')
    offline_score3.to_excel(writer,sheet_name='offline_score3')
    offline_score4.to_excel(writer,sheet_name='offline_score4')

2，列表统计元素数量

1，字典统计
a = [1, 2, 3, 1, 1, 2]
dict = {}
for key in a:
    dict[key] = dict.get(key, 0) + 1
print(dict)

2，collections统计

from collections import Counter
a = [1, 2, 3, 1, 1, 2]
result = Counter(a)
print(result)

3,两个列表找到相同和不同元素

1，集合方法
list1 = [1,2,3]
list2=[2,3,4]
set1 = set(list1)
set2 = set(list2)

print(set1&set2)
{2, 3}
print(set1^set2)
{1, 4}

2，for方法
y1 = [1,2,3]
y2 = [2,3,4]

def find_diff_intwo_list(list1,list2):
    same,diff=[],[]
    seq=list(set(list2))
    for i in list(set(list1)):
        if i not in list2:
            diff.append(i)
        else:
            same.append(i)
    for j in same:
        seq.remove(j)
    print("same is {},a_diff is {},b_diff is {}".format(same,diff,seq))
    return same,diff,seq

z1,z2,z3 = find_diff_intwo_list(y1,y2)
3，counter方法
from collections import Counter

list1 = [1,2,3,5,7,7,7,98]
list2 = [93,0,2,6,7,98]

def find_diff_by_twolist(list1,list2):
    newli=list(set(list1)) + list(set(list2))
    count=Counter(newli)
    same, diff = [], []
    for i in count.keys():
        print(i)
        if(count.get(i)>=2):
            same.append(i)
        else:
            diff.append(i)
    print("same is {},diff is {}".format(same, diff))