pandas的查询问题，需要两列索引

Question

我需要指定股票，指定日期的价格，请问我怎么索引。
另外列日期我想加一天，但是直接加会导致产生比如1月32号，我应该怎么加。

Answer 1

import pandas as pd

data =[['00001.sz', '20220302', 15.68],
       ['00001.sz', '20220224', 15.91],
       ['00001.sz', '20220218', 16.77],
       ['00002.sz', '20220302', 19.32],
       ['00002.sz', '20220228', 19.20],
       ['00004.sz', '20220301', 21.65],
       ['00002.sz', '20220211', 21.18],
       ['00005.sz', '20220228', 2.20]]

df = pd.DataFrame(data, columns = ['ts_code', 'trade_date', 'close'])

print(df)
select = df[(df['ts_code']=='00001.sz') & (df['trade_date']=='20220302')]
print(select)

df['trade_date'] = pd.to_datetime(df['trade_date']) + pd.Timedelta(days = 1)
print(df)