python panda读取excel_python使用pandas读取excel

# -*- coding: utf-8 -*-

import pandas as pd

from collections import defaultdict

import json

from pathlib import Path

DATA = "6.28"

dd = defaultdict(list)

def save_file(l, filename="sss"):

_temp = Path().cwd()

file_path = _temp / f"{filename}_list.txt"

with file_path.open("w", encoding="utf-8") as fs:

fs.write("\n".join(l))

def excel_to_list():

sExcelFile = "./update_video_task.xlsx"

df = pd.read_excel(sExcelFile, sheet_name=‘sheet1‘)

df = df.fillna(method=‘ffill‘)

df = df.loc[:, ~df.columns.str.contains(‘^Unnamed‘)]

d = df.to_dict("records")

return d

def gen_new_list(l, data=DATA):

for d in l:

if str(d["data"]) == data:

nam