import pandas as pd def str2time(s): df0 = s.str.extract("(翌日)?(\d{1,2}):(\d{1,2})").rename( columns={0: "day", 1: "hour", 2: "minute"} ) df0["day"] = df0["day"].map({"翌日": 1}) df1 = df0.fillna(0).astype(int) result = df1.apply( lambda…

Google Colabからの認証で簡単になってたので使いやすい docs.gspread.org Pandasからの書き込みも簡単になってた docs.gspread.org !pip install -U gspread import pandas as pd cities = [ "今治市", "新居浜市", "西条市", "四国中央市", "上島町", "松…