if you want the project pls call @8125424511
Investment Requirement Analysis for a company
Project Brief
You work for Teclov, an asset management company. Teclov wants to make investments in a few companies. The CEO of Teclov wants to understand the global trends in investments so that she can take the investment decisions effectively.
Business and Data Understanding
Teclov has two minor constraints for investments:
1. It wants to invest between 5 to 15 million USD per round of investment
2. It wants to invest only in English-speaking countries because of the ease of communication with the companies it would invest in
For your analysis, consider a country to be English speaking only if English is one of the official languages in that country
You may use this list: Click here for a list of countries where English is an official language.
These conditions will give you sufficient information for your initial analysis. Before getting to specific questions, let’s understand the problem and the data first.
1. What is the strategy?
Teclov wants to invest where most other investors are investing. This pattern is often observed among early stage startup investors.
2. Where did we get the data from?
We have taken real investment data from crunchbase.com, so the insights you get may be incredibly useful. For this group project, we have divided the data into the following files: You have to use three main data tables for the entire analysis
3. What is Teclov’ business objective?
The business objectives and goals of data analysis are pretty straightforward.
1. Business objective: The objective is to identify the best sectors, countries, and a suitable investment type for making investments. The overall strategy is to invest where others are investing, implying that the 'best' sectors and countries are the ones 'where most investors are investing'.
2. Goals of data analysis: Your goals are divided into three sub-goals:
○ Investment type analysis: Comparing the typical investment amounts in the venture, seed, angel, private equity etc. so that Teclov can choose the type that is best suited for their strategy.
○ Country analysis: Identifying the countries which have been the most heavily invested in the past. These will be Teclov’ favourites as well.
○ Sector analysis: Understanding the distribution of investments across the eight main sectors. (Note that we are interested in the eight 'main sectors' provided in the mapping file. The two files — companies and rounds2 — have numerous sub-sector names; hence, you will need to map each sub-sector to its main sector.)
1. Company details
companies: A table with basic data of companies
3. Sector Classification:
mapping.csv: This file maps the numerous category names in the companies table (such 3D printing, aerospace, agriculture, etc.) to eight broad sector names. The purpose is to simplify the analysis into eight sector buckets, rather than trying to analyse hundreds of them.
Problem 1: Data Cleaning 1
1. Load the companies and rounds data into two data frames and name them companies and rounds2 respectively.
2. Table 1.1:
Results Expected: Table 1.1
Table 1.1: Understand the Data Set
How many unique companies are present in rounds2?
How many unique companies are present in companies?
In the companies data frame, which column can be used as the unique key for each company? Write the name of the column.
Are there any companies in the rounds2 file which are not present in companies? Answer yes or no: Y/N
Merge the two data frames so that all variables (columns) in the ompanies frame are added to the rounds2 data frame. Name the
merged frame master_frame. How many observations are present in master_frame?
After this, you will need to work only with the master frame.
thank you for your comment
pls call me on 8125424511