英文:
Find latest date value in a dictionary
问题
我有这段代码，用于请求股票MSFT（Microsoft）的信息，请求成功并获取到所需的所有数据，但是我想要获取最新的股票价格（在Python中，数据以最新到最旧的方式排序，但我不想从顶部获取数据，因为某些语言没有为我排序）。在下面给出的结果中，有多个日期，例如：
{u'2019-10-08':
现在我想要在JSON数据中找到最新的日期，并打印出来。
我正在使用Alpha Advantage获取这些数据，给定的数据没有问题。
import requests,jsonfunc = 'function=TIME_SERIES_DAILY'sym = 'symbol=MSFT'inter = 'interval=10min'apikey = 'apikey=**********'url = 'https://www.alphavantage.co/query?'+func+'&'+sym+'&'+inter+'&'+apikeyresp = requests.get(url)data = json.loads(resp.content)d = data['Time Series (Daily)']# print (d['2020-01-03']) #<- date# print (max(d.values())) # does not give the expected data (i think because the date is in a string)print (d)
缩短的结果：
{u'Meta Data': {u'1. Information': u'Daily Prices (open, high, low, close) and Volumes', u'4.Output Size': u'Compact', u'5. Time Zone': u'US/Eastern', u'2. Symbol': u'MSFT', u'3. LastRefreshed': u'2020-01-03'}, u'Time Series (Daily)': {u'2019-10-08': {u'5. volume': u'26783336',u'4. close': u'135.6700', u'2. high': u'137.7600', u'1. open': u'137.0800', u'3. low': u'135.6200'}}
我已经查看了许多答案，其中一些没有答案，另一些答案使用不同的语言，我已经花了一些时间尝试找到解决方案。
英文:
I have this code that requests the information of the stock MSFT (Microsoft), the request goes right and i get all the data i need on it, however it i want to get the latest stock price (in python it sorts it out latest to oldest however i do not want to take the data off the top because some languages do not sort it out for me) in the result given below, there are multiple dates eg:
{u'2019-10-08':
Now i want to find the latest date in the json data and print THAT out.
I am using Alpha advantage to get this data, there is nothing wrong with the given data.
import requests,jsonfunc = 'function=TIME_SERIES_DAILY'sym = 'symbol=MSFT'inter = 'interval=10min'apikey = 'apikey=**********'url = 'https://www.alphavantage.co/query?'+func+'&'+sym+'&'+inter+'&'+apikeyresp = requests.get(url)data = json.loads(resp.content)d = data['Time Series (Daily)']# print (d['2020-01-03']) #<- date# print (max(d.values())) # does not give the expected data (i think because the date is in a string)print (d)
Shortened Result:
{u'Meta Data': {u'1. Information': u'Daily Prices (open, high, low, close) and Volumes', u'4.Output Size': u'Compact', u'5. Time Zone': u'US/Eastern', u'2. Symbol': u'MSFT', u'3. LastRefreshed': u'2020-01-03'}, u'Time Series (Daily)': {u'2019-10-08': {u'5. volume': u'26783336',u'4. close': u'135.6700', u'2. high': u'137.7600', u'1. open': u'137.0800', u'3. low': u'135.6200'}}
I have looked through many answers and some of them unanswered or few in different languages, I have spend some time trying to get the solution to this.
答案1
得分: 3
如果我正确理解你的问题，你可以使用datetime.strptime()来执行以下操作。请注意，在你的情况下，正如 @Iguananaut 指出的那样，日期格式是按词典顺序排列的，所以你可以直接使用 maxdate = max(d)。
from datetime import datetimemaxdate = max((x for x in d.keys()), key=lambda x: datetime.strptime(x, "%Y-%m-%d"))print(maxdate)print(d[maxdate])
这将给我以下输出：
2020-01-03{'1. open': '158.3200','2. high': '159.9450','3. low': '158.0600','4. close': '158.6200','5. volume': '21121681'}
英文:
If I understand the question correctly, you could do the following using datetime.strptime(). Note that in your case, as @Iguananaut pointed out, the date format is in lexicographical order, so you could just use maxdate = max(d).
from datetime import datetimemaxdate = max((x for x in d.keys()), key=lambda x: datetime.strptime(x, "%Y-%m-%d"))print(maxdate)print(d[maxdate])
Which gives me output:
2020-01-03{'1. open': '158.3200','2. high': '159.9450','3. low': '158.0600','4. close': '158.6200','5. volume': '21121681'}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论