Startups Case Study Through Python

In this case study we will wear the Venture Capital hat & analyze top VC-backed companies globally, their industry trends, and the amount of funding raised.

Learn the following Python Concepts:

• How to write total rows and columns in Python
• How to get N rows of data in Python
• How to select specific columns in Python
• How to rename columns in Python
• How to use conditional filtering in Python
  
• How to use multiple conditional filtering in Python
  
• How to use AND and OR conditional filtering in Python
• How to use the Between operator in Python
• How to use Mathematical Functions in Python
• How to use Statistical Functions 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 use numbered aliasing in Python for grouping and sorting
• How to Sort data in Python
• How to use String Functions in Python
  • How to Calculate the Length of a string in Python
    
  • How to Extract characters from a string in Python
  • How to Clean string columns in Python
  • How to concatenate different strings in Python
  • How to use the Like function to filter data in Python
• How to use Date Functions in Python
  • How to convert a column into datetime format in Python
  • How to extract parts of date from a column in Python

Learn the following Concepts about Startups:

• How to Get all startups from a particular country
• How to find startups which raised more than 1 Billion Dollars
• How to get startups from a specific category
• How to analyze various funding rounds for startups
• How to find out total startup funding raised for a startup, country, or category
• How to find out total startups in a country, or a category
• How to find the top countries or categories which raised the most startup funding
• How to analyze names of companies
  
• How to standardize category codes
• How to analyze the founding date for these startups