ValueError: Excel does not support datetimes with timezones. のエラー解消法

前提・実現したいこと

PythonとTwitter APIを使用して特定のアカウントのツイートをExcelファイルに出力したいです。

ですがエラーメッセージ最終行にある、
「ValueError: Excel does not support datetimes with timezones.
Please ensure that datetimes are timezone unaware before writing to Excel. 」
の解消法が分からず困っています。

ご存じの方がいらっしゃいましたらご教授いただけますと幸いです。
使用エディタはJupyter Labです。

発生している問題・エラーメッセージ

---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
Input In [40], in <cell line: 10>()
      7     df.to_excel('tw_%s.xlsx'%tw_id, sheet_name='Sheet1')
      9     print("end")
---> 10 get_tweets()

Input In [40], in get_tweets()
      5     tweet_data.append([tweet.id,tweet.created_at,tweet.created_at+datetime.timedelta(hours=9),tweet.text.replace('\n',''),tweet.favorite_count,tweet.retweet_count])
      6 df = pd.DataFrame(tweet_data,columns=columns_name)
----> 7 df.to_excel('tw_%s.xlsx'%tw_id, sheet_name='Sheet1')
      9 print("end")

File ~/opt/anaconda3/lib/python3.9/site-packages/pandas/core/generic.py:2345, in NDFrame.to_excel(self, excel_writer, sheet_name, na_rep, float_format, columns, header, index, index_label, startrow, startcol, engine, merge_cells, encoding, inf_rep, verbose, freeze_panes, storage_options)
   2332 from pandas.io.formats.excel import ExcelFormatter
   2334 formatter = ExcelFormatter(
   2335     df,
   2336     na_rep=na_rep,
   (...)
   2343     inf_rep=inf_rep,
   2344 )
-> 2345 formatter.write(
   2346     excel_writer,
   2347     sheet_name=sheet_name,
   2348     startrow=startrow,
   2349     startcol=startcol,
   2350     freeze_panes=freeze_panes,
   2351     engine=engine,
   2352     storage_options=storage_options,
   2353 )

File ~/opt/anaconda3/lib/python3.9/site-packages/pandas/io/formats/excel.py:894, in ExcelFormatter.write(self, writer, sheet_name, startrow, startcol, freeze_panes, engine, storage_options)
    891     need_save = True
    893 try:
--> 894     writer.write_cells(
    895         formatted_cells,
    896         sheet_name,
    897         startrow=startrow,
    898         startcol=startcol,
    899         freeze_panes=freeze_panes,
    900     )
    901 finally:
    902     # make sure to close opened file handles
    903     if need_save:

File ~/opt/anaconda3/lib/python3.9/site-packages/pandas/io/excel/_xlsxwriter.py:227, in XlsxWriter.write_cells(self, cells, sheet_name, startrow, startcol, freeze_panes)
    224 if validate_freeze_panes(freeze_panes):
    225     wks.freeze_panes(*(freeze_panes))
--> 227 for cell in cells:
    228     val, fmt = self._value_with_fmt(cell.val)
    230     stylekey = json.dumps(cell.style)

File ~/opt/anaconda3/lib/python3.9/site-packages/pandas/io/formats/excel.py:832, in ExcelFormatter.get_formatted_cells(self)
    830 def get_formatted_cells(self) -> Iterable[ExcelCell]:
    831     for cell in itertools.chain(self._format_header(), self._format_body()):
--> 832         cell.val = self._format_value(cell.val)
    833         yield cell

File ~/opt/anaconda3/lib/python3.9/site-packages/pandas/io/formats/excel.py:547, in ExcelFormatter._format_value(self, val)
    545         val = float(self.float_format % val)
    546 if getattr(val, "tzinfo", None) is not None:
--> 547     raise ValueError(
    548         "Excel does not support datetimes with "
    549         "timezones. Please ensure that datetimes "
    550         "are timezone unaware before writing to Excel."
    551     )
    552 return val

ValueError: Excel does not support datetimes with timezones. Please ensure that datetimes are timezone unaware before writing to Excel.

該当のソースコード

Python3
1#ツイートをエクセルファイルに出力する
2import tweepy
3import pandas as pd
4import datetime
5
6# TweepyAPI KEY
7CONSUMER_KEY = "XXXXXXXXXXXXXXXXXXXXXXXXX"
8CONSUMER_SECRET = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
9ACCESS_TOKEN = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
10ACCESS_TOKEN_SECRET = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
11
12#tweepyの設定
13auth = tweepy.OAuthHandler(CONSUMER_KEY, CONSUMER_SECRET)
14auth.set_access_token(ACCESS_TOKEN, ACCESS_TOKEN_SECRET)
15api = tweepy.API(auth)
16columns_name=["TW_NO","TW_TIME","TW_TIME_JPN","TW_TEXT","RT","FAV"]
17
18#ここで取得したいツイッターアカウントIDを指定する
19tw_id="karupoimou"
20
21#ツイート取得
22def get_tweets():
23    tweet_data = []
24    for tweet in tweepy.Cursor(api.user_timeline,screen_name = tw_id,exclude_replies = True).items():
25        tweet_data.append([tweet.id,tweet.created_at,tweet.created_at+datetime.timedelta(hours=9),tweet.text.replace('\n',''),tweet.favorite_count,tweet.retweet_count])
26    df = pd.DataFrame(tweet_data,columns=columns_name)
27    df.to_excel('tw_%s.xlsx'%tw_id, sheet_name='Sheet1')
28    
29    print("end")
30get_tweets()