{"cells":[{"metadata":{},"cell_type":"markdown","source":"## CDP: Unlocking Climate Solutions. Data Understanding."},{"metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true,"_kg_hide-input":true,"_kg_hide-output":true},"cell_type":"code","source":"import numpy as np\nimport pandas as pd\n\nimport os\nfor dirname, _, filenames in os.walk('/kaggle/input'):\n    for filename in filenames:\n        print(os.path.join(dirname, filename))","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"<a id=\"1\"></a>\n<h2 style='background:black; border:0; color:white'><center>1. Corporation Responses<center><h2>"},{"metadata":{},"cell_type":"markdown","source":"Let's check column names and descriptions for them."},{"metadata":{"trusted":true},"cell_type":"code","source":"check_corporations = pd.read_csv(\n    '/kaggle/input/cdp-unlocking-climate-solutions/Corporations/Corporations Responses/Water Security/Full_Corporations_Response_Data_Dictionary.csv'\n)\n\nfor index, row in check_corporations.iterrows():\n    print(index, '.', row['field'], ': ', row['description'])","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"check_corporations = pd.read_csv(\n    '/kaggle/input/cdp-unlocking-climate-solutions/Corporations/Corporations Responses/Climate Change/Full_Corporations_Response_Data_Dictionary copy.csv'\n)\n\nfor index, row in check_corporations.iterrows():\n    print(index, '.', row['field'], ': ', row['description'])","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"We can see that columns for Water Security and Climate Change are exactly the same."},{"metadata":{"_uuid":"d629ff2d2480ee46fbb7e2d37f6b5fab8052498a","_cell_guid":"79c7e3d0-c299-4dcb-8224-4455121ee9b0","trusted":true},"cell_type":"code","source":"fccd_2020_df = pd.read_csv(\n    '../input/cdp-unlocking-climate-solutions/Corporations/Corporations Responses/Climate Change/2020_Full_Climate_Change_Dataset.csv'\n)\nfccd_2020_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"fccd_2019_df = pd.read_csv(\n    '../input/cdp-unlocking-climate-solutions/Corporations/Corporations Responses/Climate Change/2019_Full_Climate_Change_Dataset.csv'\n)\nfccd_2019_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"fccd_2018_df = pd.read_csv(\n    '../input/cdp-unlocking-climate-solutions/Corporations/Corporations Responses/Climate Change/2018_Full_Climate_Change_Dataset.csv'\n)\nfccd_2018_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"fwsd_2020_df = pd.read_csv(\n    '../input/cdp-unlocking-climate-solutions/Corporations/Corporations Responses/Water Security/2020_Full_Water_Security_Dataset.csv'\n)\nfwsd_2020_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"fwsd_2019_df = pd.read_csv(\n    '../input/cdp-unlocking-climate-solutions/Corporations/Corporations Responses/Water Security/2019_Full_Water_Security_Dataset.csv'\n)\nfwsd_2019_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"fwsd_2018_df = pd.read_csv(\n    '../input/cdp-unlocking-climate-solutions/Corporations/Corporations Responses/Water Security/2018_Full_Water_Security_Dataset.csv'\n)\nfwsd_2018_df.head()","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"<a id=\"2\"></a>\n<h2 style='background:black; border:0; color:white'><center>2. Cities Responses<center><h2>"},{"metadata":{"trusted":true},"cell_type":"code","source":"check_corporations = pd.read_csv(\n    '/kaggle/input/cdp-unlocking-climate-solutions/Cities/Cities Responses/Full_Cities_Response_Data_Dictionary.csv'\n)\n\nfor index, row in check_corporations.iterrows():\n    print(index, '.', row['field'], ': ', row['description'])","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cities_2020_df = pd.read_csv(\n    \"../input/cdp-unlocking-climate-solutions/Cities/Cities Responses/2020_Full_Cities_Dataset.csv\"\n)\ncities_2020_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cities_2019_df = pd.read_csv(\n    \"../input/cdp-unlocking-climate-solutions/Cities/Cities Responses/2019_Full_Cities_Dataset.csv\"\n)\ncities_2019_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cities_2018_df = pd.read_csv(\n    \"../input/cdp-unlocking-climate-solutions/Cities/Cities Responses/2018_Full_Cities_Dataset.csv\"\n)\ncities_2018_df.head()","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"<a id=\"3\"></a>\n<h2 style='background:black; border:0; color:white'><center>3. Corporations Disclosing<center><h2>"},{"metadata":{"trusted":true},"cell_type":"code","source":"check = pd.read_csv(\n    '/kaggle/input/cdp-unlocking-climate-solutions/Corporations/Corporations Disclosing/Water Security/Corporations_Disclosing_to_CDP_Data_Dictionary.csv'\n)\n\nfor index, row in check.iterrows():\n    print(index, '.', row['field'], ': ', row['description'])","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"check = pd.read_csv(\n    '/kaggle/input/cdp-unlocking-climate-solutions/Corporations/Corporations Disclosing/Climate Change/Corporations_Disclosing_to_CDP_Data_Dictionary.csv'\n)\n\nfor index, row in check.iterrows():\n    print(index, '.', row['field'], ': ', row['description'])","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"Again we have the same columns for Climate Change and Water Security."},{"metadata":{"trusted":true},"cell_type":"code","source":"cdws_2018_df = pd.read_csv('/kaggle/input/cdp-unlocking-climate-solutions/Corporations/Corporations Disclosing/Water Security/2018_Corporates_Disclosing_to_CDP_Water_Security.csv')\ncdws_2018_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cdws_2019_df = pd.read_csv('/kaggle/input/cdp-unlocking-climate-solutions/Corporations/Corporations Disclosing/Water Security/2019_Corporates_Disclosing_to_CDP_Water_Security.csv')\ncdws_2019_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cdws_2020_df = pd.read_csv('/kaggle/input/cdp-unlocking-climate-solutions/Corporations/Corporations Disclosing/Water Security/2020_Corporates_Disclosing_to_CDP_Water_Security.csv')\ncdws_2020_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cdcc_2018_df = pd.read_csv('/kaggle/input/cdp-unlocking-climate-solutions/Corporations/Corporations Disclosing/Climate Change/2018_Corporates_Disclosing_to_CDP_Climate_Change.csv')\ncdcc_2018_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cdcc_2019_df = pd.read_csv('/kaggle/input/cdp-unlocking-climate-solutions/Corporations/Corporations Disclosing/Climate Change/2019_Corporates_Disclosing_to_CDP_Climate_Change.csv')\ncdcc_2019_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cdcc_2020_df = pd.read_csv('/kaggle/input/cdp-unlocking-climate-solutions/Corporations/Corporations Disclosing/Climate Change/2020_Corporates_Disclosing_to_CDP_Climate_Change.csv')\ncdcc_2020_df.head()","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"<a id=\"4\"></a>\n<h2 style='background:black; border:0; color:white'><center>4. Cities Disclosing<center><h2>"},{"metadata":{"trusted":true},"cell_type":"code","source":"check = pd.read_csv('/kaggle/input/cdp-unlocking-climate-solutions/Cities/Cities Disclosing/Cities_Disclosing_to_CDP_Data_Dictionary.csv')\n\nfor index, row in check.iterrows():\n    print(index, '.', row['field'], ': ', row['description'])","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cities_2020_discl = pd.read_csv('/kaggle/input/cdp-unlocking-climate-solutions/Cities/Cities Disclosing/2020_Cities_Disclosing_to_CDP.csv')\ncities_2020_discl.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cities_2019_discl = pd.read_csv('/kaggle/input/cdp-unlocking-climate-solutions/Cities/Cities Disclosing/2019_Cities_Disclosing_to_CDP.csv')\ncities_2019_discl.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cities_2018_discl = pd.read_csv('/kaggle/input/cdp-unlocking-climate-solutions/Cities/Cities Disclosing/2018_Cities_Disclosing_to_CDP.csv')\ncities_2018_discl.head()","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"<a id=\"5\"></a>\n<h2 style='background:black; border:0; color:white'><center>5.<center><h2>"},{"metadata":{"trusted":true},"cell_type":"code","source":"corporations = pd.concat([fccd_2020_df, fccd_2019_df, fccd_2018_df, fwsd_2020_df, fwsd_2019_df, fwsd_2018_df])\ncorporations","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"cities = pd.concat([cities_2020_df, cities_2019_df, cities_2018_df])\ncities","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"corp_locations = pd.read_csv('/kaggle/input/cdp-unlocking-climate-solutions/Supplementary Data/Locations of Corporations/NA_HQ_public_data.csv')\ncorp_locations","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"svi_df = pd.read_csv(\"../input/cdp-unlocking-climate-solutions/Supplementary Data/CDC Social Vulnerability Index 2018/SVI2018_US.csv\")\nsvi_df.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"us_cities_meta_df = pd.read_csv(\"../input/cdp-unlocking-climate-solutions/Supplementary Data/Simple Maps US Cities Data/uscities.csv\")\nus_cities_meta_df","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"## Work in progress"},{"metadata":{"trusted":true},"cell_type":"code","source":"","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"pygments_lexer":"ipython3","nbconvert_exporter":"python","version":"3.6.4","file_extension":".py","codemirror_mode":{"name":"ipython","version":3},"name":"python","mimetype":"text/x-python"}},"nbformat":4,"nbformat_minor":4}