Wtiの価格を１９８０から取得する
pip install pandas_datareader
でインストール
Collecting pandas_datareader Downloading pandas_datareader-0.10.0-py3-none-any.whl.metadata (2.9 kB) Requirement already satisfied: lxml in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from pandas_datareader) (5.4.0) Requirement already satisfied: pandas>=0.23 in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from pandas_datareader) (2.2.3) Requirement already satisfied: requests>=2.19.0 in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from pandas_datareader) (2.32.3) Requirement already satisfied: numpy>=1.23.2 in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from pandas>=0.23->pandas_datareader) (1.26.4) Requirement already satisfied: python-dateutil>=2.8.2 in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from pandas>=0.23->pandas_datareader) (2.9.0.post0) Requirement already satisfied: pytz>=2020.1 in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from pandas>=0.23->pandas_datareader) (2024.2) Requirement already satisfied: tzdata>=2022.7 in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from pandas>=0.23->pandas_datareader) (2025.1) Requirement already satisfied: six>=1.5 in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from python-dateutil>=2.8.2->pandas>=0.23->pandas_datareader) (1.17.0) Requirement already satisfied: charset-normalizer<4,>=2 in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from requests>=2.19.0->pandas_datareader) (3.4.1) Requirement already satisfied: idna<4,>=2.5 in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from requests>=2.19.0->pandas_datareader) (3.10) Requirement already satisfied: urllib3<3,>=1.21.1 in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from requests>=2.19.0->pandas_datareader) (2.3.0) Requirement already satisfied: certifi>=2017.4.17 in /Users/snowpool/.pyenv/versions/3.11.0/lib/python3.11/site-packages (from requests>=2.19.0->pandas_datareader) (2024.12.14) Downloading pandas_datareader-0.10.0-py3-none-any.whl (109 kB) Installing collected packages: pandas_datareader Successfully installed pandas_datareader-0.10.0
でインストール
import pandas_datareader.data as web
import pandas as pd
from datetime import datetime
# 開始・終了日
start = datetime(1980, 1, 1)
end = datetime.today()
# FREDからWTI価格データを取得
wti_df = web.DataReader('DCOILWTICO', 'fred', start, end)
# 欠損値を除去（必要に応じて）
wti_df.dropna(inplace=True)
# CSVに保存
wti_df.to_csv("wti_price_1980_to_present.csv")
print("✅ WTI原油価格データを保存しました：wti_price_1980_to_present.csv")
で実行
python wti_csv.py ✅ WTI原油価格データを保存しました：wti_price_1980_to_present.csv
となって
Csvファイルで取得ができた
金の価格や銀の価格も取得できるか試す