You might want to analyze crypto prices.

In order to do some portfolio analysis or other nice things.

Here is the simplest way to retrieve data from the Coingecko free API.

The documentation is available here

The cleanest

import requests

# We define the coingecko id of the crypto we want to fetch
coin_id = "bitcoin"

# We create the url that we will have to fetch
url_ohlc_coin = f"https://api.coingecko.com/api/v3/coins/{coin_id}/ohlc" 

# We set up the additional parameters to be 
# passed during the http call
query_parameters = {
    "vs_currency" : "usd",
    "days" : "14"
}

# We perform the http call against the api and get back a response object
response = requests.get(url_ohlc_coin, params=query_parameters)

# We parse the json data into a btc_prices object
btc_prices = response.json()

# We pass this dict to the pandas dataframe to create a dataframe
df_btc_prices = pd.DataFrame(btc_prices)

The cleanest way of doing it

The simplest

For the quick and dirty aficionados out there is a simpler solution. Thanks to the pandas library.

df_btc_prices = pd.read_json("https://api.coingecko.com/api/v3/coins/bitcoin/ohlc?vs_currency=usd&days=14")

The shortest way to do it

As you can see the dates are still considered as int64.

In order to format it into a human readable format you can use the pandas.to_datetime function.

I wrote an article with the code available here

How to format dates with Pandas

How to format dates with Pandas. A simple way is to use the pandas.to_datetime() method. Here are two use cases.

The Python You NeedBastien

How to get Bitcoin prices in Python for Beginners

Land Your First Data Science Job

The cleanest

The simplest

Land Your First Data Science Job

Related Articles

Master Data Science in Days, Not Months 🚀

Related Articles

API
1 min read
How to use API in Python
Use the requests library in Python to send HTTP requests to an API, process the response, e.g. check status code, parse JSON data. Example: response = requests.get(url); data = response.json() if response.status_code == 200 else print("Request failed").
3/21/2023Read More

Advanced
1 min read
How to make your own API in Python
Build an API in Python using a web framework such as Flask or Django by defining endpoints, writing functions for handling requests, mapping functions to endpoints, starting the server and testing the API by sending requests to endpoints.
3/16/2023Read More

Flask
1 min read
How to use Flask in Python
Use Flask in Python for building web applications by installing Flask, importing the Flask module, creating an instance of the Flask class, defining routes and the corresponding request handlers, and running the application using the run() method.
3/15/2023Read More