Crypto Case Study Through SQL Python

Crypto Case Study Through Python

Step into the world of Cryptocurrencies, analyze the price and market share trends for some of the top crypto currencies


Learn the following Python Concepts:

  • How to get N rows of data in Python
  • How to use Mathematical Functions in Python
  • How to apply a date filter in Python
  • How to sort data and limit number of rows in Python
  • How to create new columns using mathematical functions on existing columns in Python
  • How to apply multiple conditional filters in Python
  • How to use Statistical Functions in Python
    • Mean, Range, Standard Deviation etc.
  • How to use Date Functions in Python
    • How to extract parts of date from a column in Python
  • How to do time-series analysis of a metric in Python
  • How to use Aggregate Functions in Python
    • Count, Count Distinct, Sum, Maximum, Minimum etc.
  • How to Group data and aggregate in Python
  • How to combine Grouping and Sorting in Python

Learn the following Concepts about Crypto Currencies:

  • What are the various crypto currencies in the dataset and their daily prices
  • What is market capitalization of a crypto currency
  • How to analyze top crypto currencies based on their market capitalization
  • Understand what is circulating supply for crypto currencies
  • How to analyze crypto currencies above certain values of market capitalization
  • How to find the most/least expensive crypto currency on a particular day
  • How to analyze the price movements of Bitcoin
    • Find Mean, Range, and Volatility of Bitcoin Prices
  • How to analyze the monthly/weekly/daily trend of Bitcoin Prices
    • How to analyze the month-on-month change in Bitcoin Prices
  • How to analyze the price movements of any crypto currency
    • Find Mean, Range, and Volatility of any crypto currency
  • How to analyze the monthly/weekly/daily trend of any crypto currency
    • How to analyze the month-on-month change in any crypto currency


Complete and Continue