https://data.gov.sg/open-data-licencehttps://data.gov.sg/open-data-licence
Dataset from Singapore Department of Statistics. For more information, visit https://data.gov.sg/datasets/d_68860ef451f948e62754a830b6ae5024/view
https://data.gov.sg/open-data-licencehttps://data.gov.sg/open-data-licence
Dataset from Singapore Department of Statistics. For more information, visit https://data.gov.sg/datasets/d_ed6d4934837b4eab645814947f2ed009/view
https://data.gov.sg/open-data-licencehttps://data.gov.sg/open-data-licence
Dataset from Singapore Department of Statistics. For more information, visit https://data.gov.sg/datasets/d_c962cc79137915a91b14a1f1a1951099/view
https://www.worldbank.org/en/about/legal/terms-of-use-for-datasetshttps://www.worldbank.org/en/about/legal/terms-of-use-for-datasets
Inspired by another Kaggle user who did a similar project with Indian emigrants (https://www.kaggle.com/rajacsp/indian-migration-history)
Data sourced from World Bank database at https://datacatalog.worldbank.org/dataset/global-bilateral-migration-database. In addition to selecting the decades from 1960-2000, I added a "Total" column and a least squares regression rate column. The original CSV (SG_IMMIGRANTS.csv) is a bit messy and contains a lot of blanks because ... well Singapore is a small country.
For the two limited "melted" versions, I used pandas pd.melt() to restructure the different decades into a new column "Year" with it's corresponding "Total". Only a select few countries with substantial number of total immigrants are included (Bangladesh, China, Indonesia, Pakistan, Thailand, Philippines, India, Malaysia, Vietnam, United Kingdom). Here, the ratio refers to either the ratio of gender to decade's total or the ratio of that decade's total to the country's all-time cumulative total . e.g. Male 1960 CHN Ratio =0.510563203 means males made up 51% of the total Chinese immigrants to SG in 1960 e.g. Total 1960 MYS Ratio = 0.081202409 means 1960 contributed only 8% of the total Malaysian immigrants to SG
Hope this is clear, leave a comment if anything needs clarification!
Future version with global database csv, SG emigrants csv For select top origin/destination countries, show a positive-negative bar plot, coloured according to immigration/emigration multiple
https://data.gov.sg/open-data-licencehttps://data.gov.sg/open-data-licence
Dataset from Singapore Department of Statistics. For more information, visit https://data.gov.sg/datasets/d_453018de40b2f290e270fb62b4c87b9b/view
Not seeing a result you expected?
Learn how you can add new datasets to our index.
https://data.gov.sg/open-data-licencehttps://data.gov.sg/open-data-licence
Dataset from Singapore Department of Statistics. For more information, visit https://data.gov.sg/datasets/d_68860ef451f948e62754a830b6ae5024/view