我有一个数据帧表，其中有一个ticker列和一个date列.我想计算一下相应日期的股票价格

Question

这是指定为df的表：

日期2022-01-072022-01-06[/tr>

id	股票代码
1	PLTR
2	GME
3	AMC	2022-01-06
4	良好	2022-01-07
5	GRAB	2022-01-07
6	所有	2022-01-06
7	适用于	2022-01-06

import pandas as pd
import pandas_datareader.data as web
tickers = list(df.ticker)
prices = ( web.DataReader(tickers, data_source='yahoo', start=df.date.min().date(), end=df.date.max().date() )['Close']
.reset_index()
.melt(id_vars=['Date'])
.rename(columns={'Symbols':'ticker', 'Date':'date'})
)
prices:

日期02022-01-06 00:00:00PLTR12022-01-07 00:00:00PLTR>td style="文本对齐：right；">16.5622022-01-06 00:00:00GME31.0332022-01-07 00:00:00GME40.62[/tr>42022-01-06 00:00:00AMC2.46[/tr>52022-01-07 00:00:0062022-01-06 00:00:00良好<25.03>2022-01-07 00:00:0082022-01-06 00:00:00GRAB>6.6592022-01-07 00:00:00GRAB>6.81102022-01-06 00:00:00所有122.4112022-01-07 00:00:00ALL25.95[/tr>122022-01-06 00:00:00适用于1.26[/tr>132022-01-07 00:00:00用于2019//tr>