World Trading Dataset (2000-2022)
Trading dataset specifically about computer and communication services
@kaggle.js1js2js3js4js5_world_trading_dataset_2000_2022
Trading dataset specifically about computer and communication services
@kaggle.js1js2js3js4js5_world_trading_dataset_2000_2022
This dataset is to showing import and export percentages of every trading country on planet specifically for computer and communication services. You can approch directly cleaning the data or you can try to transform the dataset according to usage
Source: https://data.worldbank.org/
CREATE TABLE import_export_of_all_countries (
"country_name" VARCHAR,
"country_code" VARCHAR,
"series_name" VARCHAR,
"series_code" VARCHAR,
"n_2000_yr2000" VARCHAR -- 2000 [YR2000],
"n_2001_yr2001" VARCHAR -- 2001 [YR2001],
"n_2002_yr2002" VARCHAR -- 2002 [YR2002],
"n_2003_yr2003" VARCHAR -- 2003 [YR2003],
"n_2004_yr2004" VARCHAR -- 2004 [YR2004],
"n_2005_yr2005" VARCHAR -- 2005 [YR2005],
"n_2006_yr2006" VARCHAR -- 2006 [YR2006],
"n_2007_yr2007" VARCHAR -- 2007 [YR2007],
"n_2008_yr2008" VARCHAR -- 2008 [YR2008],
"n_2009_yr2009" VARCHAR -- 2009 [YR2009],
"n_2010_yr2010" VARCHAR -- 2010 [YR2010],
"n_2011_yr2011" VARCHAR -- 2011 [YR2011],
"n_2012_yr2012" VARCHAR -- 2012 [YR2012],
"n_2013_yr2013" VARCHAR -- 2013 [YR2013],
"n_2014_yr2014" VARCHAR -- 2014 [YR2014],
"n_2015_yr2015" VARCHAR -- 2015 [YR2015],
"n_2016_yr2016" VARCHAR -- 2016 [YR2016],
"n_2017_yr2017" VARCHAR -- 2017 [YR2017],
"n_2018_yr2018" VARCHAR -- 2018 [YR2018],
"n_2019_yr2019" VARCHAR -- 2019 [YR2019],
"n_2020_yr2020" VARCHAR -- 2020 [YR2020],
"n_2021_yr2021" VARCHAR -- 2021 [YR2021],
"n_2022_yr2022" VARCHAR -- 2022 [YR2022]
);Anyone who has the link will be able to view this.