top of page

Companies House Charts (Day 3 of 5)

My exploratory data analysis of Companies House data in August 2020:

Number of Incorporations by City from January 2020

Next the limitations:

  • Delays in registering new companies has likely been inconsistent across cities

  • The City field isn't always filled correctly

And the code snippet:

#bind UK total
data %>%
group_by(IncorporationDate_ym) %>%
summarise(.groups = "keep",
    city_incorporationdateMonth_count = sum(city_incorporationdateMonth_count)
) %>%
ungroup() %>%
    city_incorporationdateMonth_perc = city_incorporationdateMonth_count / sum(city_incorporationdateMonth_count),
    RegAddress.PostTown_fct = as_factor("UK") %>% fct_relevel("UK",after=Inf)
) %>%
select(RegAddress.PostTown_fct,IncorporationDate_ym, city_incorporationdateMonth_perc, city_incorporationdateMonth_count) %>%
rbind(temp_IncorporationDate_ym) %>%

Recent Posts

See All

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo


Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page