TL;DR

A trimmed version of this analysis (without code) is published in medium.

1 Background

Republica published a story that Lawmakers in Nepal are planning to put several sectors in negative list for FDI. They might or mightn’t have done some analysis on what the FDI data says. In case they haven’t, i thought i might take a look at that.

Fortunately data is maintained in the website of Department of Industry, but unfortunately most of their data is in PDF as usual. I created CSV file from PDF and cleaned that up - the scrapping and cleanup process is for another day.

2 Data Loading

First we need to load the clean data and do basic cleanup and transformation. The clean data set already has segregated the Local and Foreign share in the company into separate columns.

Total industries: 6519

3 Data analysis

3.1 Companies Registration Trend

We have the year column ready for quick charts. So first we can quickly see in which year industries are registering.

3.1.1 Year and Monthwise Registration

Lets create a table with the count of registration based on year and month.

Registration Year (Nepali) Month (Nepali) Total
1 2 3 4 5 6 7 8 9 10 11 12
2018 1 1
2022 1 1 2
2030 1 2 1 4
2032 1 1
2033 1 1 2
2034 1 1 2
2035 1 1 2
2037 1 1 2
2038 1 1
2039 2 1 1 1 5
2040 1 1
2041 1 1 2
2042 1 1 1 3
2043 1 1 1 2 5
2044 1 1 1 1 4
2045 1 1 1 1 1 1 6
2046 1 1 1 1 4
2047 9 12 7 7 20 16 8 11 6 96
2048 10 18 11 8 13 12 13 12 13 20 11 36 177
2049 105 75 118 133 124 47 216 17 23 14 3 3 878
2050 3 11 12 7 6 12 8 12 13 14 11 18 127
2051 13 12 21 21 20 15 11 16 16 16 12 20 193
2052 10 26 30 24 24 15 27 36 40 33 34 36 335
2053 35 38 31 20 22 32 10 21 20 19 23 19 290
2054 18 20 18 9 13 8 9 15 5 7 12 13 147
2055 7 5 9 9 10 4 4 3 5 13 9 17 95
2056 6 12 19 11 7 16 2 8 14 19 11 21 146
2057 19 18 13 13 9 17 11 16 9 15 11 11 162
2058 12 9 12 10 10 23 8 17 9 16 8 10 144
2059 8 9 11 13 13 7 9 6 11 6 7 4 104
2060 11 21 6 10 13 15 7 14 11 13 15 13 149
2061 8 11 12 23 9 8 7 7 4 8 5 6 108
2062 11 10 9 12 11 12 3 14 13 5 10 11 121
2063 7 9 13 10 17 12 9 16 13 11 13 10 140
2064 24 20 22 18 17 28 9 17 11 18 25 15 224
2065 13 26 30 20 34 24 29 23 21 13 25 18 276
2066 20 30 44 21 27 21 19 28 13 20 13 19 275
2067 16 35 24 27 23 22 9 17 17 14 18 19 241
2068 16 28 32 30 24 19 21 27 10 15 12 26 260
2069 22 36 37 46 34 51 25 32 24 30 29 27 393
2070 46 61 41 38 25 34 15 16 19 26 19 34 374
2071 48 54 43 31 43 48 35 32 36 36 24 41 471
2072 19 60 58 32 47 40 29 26 18 5 23 33 390
2073 36 61 59 156

3.1.2 Registration Trend

Lets quickly draw a chart showing the trend of industry registration.

We see that there’s spark spike of company registration in 2049 and declines in subsequent years. It would be interesting to see why there’s such a remarkable increase in the registration. I would be happy to see some researcher looking into the year 2049 BS and see what happened in Nepal.

The trend is in increase mode since 2064.