In this article, we will discuss data cleaning and some insights from the analysis of fund investment companies. The investment company wants to know the top nine countries for investment from the data. The data is available here. We observe that the two data have column permalink and company permalink, in which the organization name at first index of both data frame is same but one is in capital and one is in lower case. Now, we will check the number of unique companies in both the data set.

Oil and gas (O&G) sources will still supply around 50% of the global energy demand by 2040.a In this article, we make the case for why the Arab region is well positioned for building world-class data science teams to fill the supply shortage of data professionals,5 especially in the O&G field critical to region's economy. This article presents challenges facing O&G industry players, such as governments, regulatory bodies, operators, and investors, and shows how Raisa Energy (with its Egypt-based data science team) is efficiently and effectively solving these challenges. Such challenges aim at assessing the economic viability of an O&G asset that depends on several factors (as shown in the accompanying figure) such as estimating well production, O&G prices, and risks associated with inputs uncertainty. It is worth emphasizing that the challenges presented here are global in nature and yet are tackled with a team fully formed from the region working at a world-class research and development level.