UTC 时间(unix 时间戳)转换为人类可读格式然后合并其他数据的问题

发布于 2025-01-16 14:11:02 字数 1932 浏览 4 评论 0原文

我使用 API 来获取数据,然后分配

给“sol_tvl_df”类。

from defillama import DefiLlama
import requests
import pandas
import ccxt
from math import sqrt
import time
import json
from typing import List, Union
import numpy

_binance = ccxt.binanceusdm()

BASE_URL = "https://api.llama.fi"

class DefiLlama:
    """
    DeFi Llama class to act as DeFi Llama's API client.
    All the requests can be made through this class.
    """

    def __init__(self):
        """
        Initialize the object
        """
        self.session = requests.Session()

    def _send_message(self, method, endpoint, params=None, data=None):
        url = BASE_URL + endpoint
        response = self.session.request(method, url, params=params, data=data, timeout=30)
        return response.json()
    
sol_tvl_df = DefiLlama()._send_message('GET', '/charts/solana' )

在 API 请求之后,我得到了如下数据:

print (sol_tvl_df)

[{'date': '1616025600', 'totalLiquidityUSD': 148988798.24},
 {'date': '1616112000', 'totalLiquidityUSD': 153204288.86},
 {'date': '1616198400', 'totalLiquidityUSD': 147690914.44},
 {'date': '1616284800', 'totalLiquidityUSD': 151935325.31},
 {'date': '1616371200', 'totalLiquidityUSD': 152981122.24},
 {'date': '1616457600', 'totalLiquidityUSD': 162065402.5018374},
 {'date': '1616544000', 'totalLiquidityUSD': 156101310.64592892},
 {'date': '1616630400', 'totalLiquidityUSD': 144439504.2605513},
 {'date': '1616716800', 'totalLiquidityUSD': 135610450.40169644},
 {'date': '1616803200', 'totalLiquidityUSD': 147786656.29307032},
 {'date': '1616889600', 'totalLiquidityUSD': 172583243.64011288}
 .............]

现在,我想选择“日期”的所有部分来转换为 iso8601 的日期格式,以实现人类可读的状态,例如

2022-03-22 00:00:00+00:00然后也许让它们合并到其他数据中。

我尝试了很多次并用谷歌搜索,但没有得到答案。

请大家帮帮我,

我已经尝试过:

ts_int_list = ( ", ".join( repr(e) for e in sol_tvl_df ) )
ts_int_list = ts_int_list.get(date)

I had used the API to get a data and then asign

to "sol_tvl_df" class.

from defillama import DefiLlama
import requests
import pandas
import ccxt
from math import sqrt
import time
import json
from typing import List, Union
import numpy

_binance = ccxt.binanceusdm()

BASE_URL = "https://api.llama.fi"

class DefiLlama:
    """
    DeFi Llama class to act as DeFi Llama's API client.
    All the requests can be made through this class.
    """

    def __init__(self):
        """
        Initialize the object
        """
        self.session = requests.Session()

    def _send_message(self, method, endpoint, params=None, data=None):
        url = BASE_URL + endpoint
        response = self.session.request(method, url, params=params, data=data, timeout=30)
        return response.json()
    
sol_tvl_df = DefiLlama()._send_message('GET', '/charts/solana' )

After API request, then I got thos data as below:

print (sol_tvl_df)

[{'date': '1616025600', 'totalLiquidityUSD': 148988798.24},
 {'date': '1616112000', 'totalLiquidityUSD': 153204288.86},
 {'date': '1616198400', 'totalLiquidityUSD': 147690914.44},
 {'date': '1616284800', 'totalLiquidityUSD': 151935325.31},
 {'date': '1616371200', 'totalLiquidityUSD': 152981122.24},
 {'date': '1616457600', 'totalLiquidityUSD': 162065402.5018374},
 {'date': '1616544000', 'totalLiquidityUSD': 156101310.64592892},
 {'date': '1616630400', 'totalLiquidityUSD': 144439504.2605513},
 {'date': '1616716800', 'totalLiquidityUSD': 135610450.40169644},
 {'date': '1616803200', 'totalLiquidityUSD': 147786656.29307032},
 {'date': '1616889600', 'totalLiquidityUSD': 172583243.64011288}
 .............]

Now, I want to select all part of 'date' to convert to date format of iso8601 for human readable status like

2022-03-22 00:00:00+00:00 then maybe let them to merge into the other data.

I tried so many times and google it, but I didn't get answer.

Would you guys help me, please

I have tried this:

ts_int_list = ( ", ".join( repr(e) for e in sol_tvl_df ) )
ts_int_list = ts_int_list.get(date)

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文