<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Lucianosantosg on Medium]]></title>
        <description><![CDATA[Stories by Lucianosantosg on Medium]]></description>
        <link>https://medium.com/@lucianosantosg3?source=rss-eab6b9636e09------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*3gX2ou8wqye1gxOZ</url>
            <title>Stories by Lucianosantosg on Medium</title>
            <link>https://medium.com/@lucianosantosg3?source=rss-eab6b9636e09------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 07:58:27 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@lucianosantosg3/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Medallion Architecture pipeline in an OOP structure]]></title>
            <link>https://medium.com/@lucianosantosg3/medallion-architecture-pipeline-in-an-oop-structure-d3290ace29b4?source=rss-eab6b9636e09------2</link>
            <guid isPermaLink="false">https://medium.com/p/d3290ace29b4</guid>
            <category><![CDATA[python]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[spark]]></category>
            <category><![CDATA[data-engineering]]></category>
            <dc:creator><![CDATA[Lucianosantosg]]></dc:creator>
            <pubDate>Mon, 24 Feb 2025 21:55:58 GMT</pubDate>
            <atom:updated>2026-05-18T14:20:50.924Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/881/1*4bt1UZMvia7005_wavKs9Q.png" /></figure><p>In this brief article, we are going to explore the steps of a standard Spark Medallion architecture pipeline in an Object-Oriented Programming context. This approach encapsulates in methods every pipeline step:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/388/1*XIw-IDWgup0TzGnXCb1bjQ.png" /><figcaption>Libraries needed</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/484/1*edcZeiNR3yZWazL7sYGIEw.png" /><figcaption>The API data url and my Kaggle file path</figcaption></figure><p>1- Creates a Spark cluster;</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/871/1*ixOo6z9mUA_tQtaREbybmg.png" /></figure><p>2- Downloads data from the API URL;</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/617/1*ObRrcZKHWtFc8oYlwyd_FQ.png" /></figure><p>3- Creates a CSV file from the data;</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/698/1*7Hpafi-nHtnsOnX4QM1yig.png" /></figure><p>4- Creates the dataframe bronze layer;</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/767/1*Ei9W4y4ibDapBMBXb1ZuSA.png" /></figure><p>5- Creates the dataframe silver layer;</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/939/1*UTqOOVNZo2ehEVIgLfjM-Q.png" /></figure><p>6- Creates the dataframe gold layer.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/841/1*eBynsesj34-vhtGhZinTOw.png" /></figure><p>As the main picture says, the bronze layer is where the raw data is stored from the source. The silver layer is applied to data cleansing(ex: eliminating duplicates, null values, and corrupted data) and business rules. The gold layer is where we apply a final business filter, performance enhancement, and aggregation for the presentation layer.</p><p>Now, the main program starts. First, create an object instance and a Spark cluster:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/310/1*AG6ZQkONFmuMyx1i7nurJA.png" /></figure><p>The <em>create_csv_file</em> method creates a CSV file in my file path:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/493/1*qVrtR8JVfbIHfbOvHYP_Yg.png" /></figure><p>The <em>create_bronze_layer</em> method returns a dataframe with the raw data from the source:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MvdxC104-cz_PxG3OTbRAQ.png" /></figure><p>The <em>create_silver_layer</em> method returns a dataframe with data cleansing(dropping some columns) and some business rules applied (renamed columns):</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*i0uRnA1Zrh8m3XEK01xYHw.png" /></figure><p>The <em>create_gold_layer</em> method returns a dataframe with a final aggregation for the presentation layer:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/486/1*nwYMQjyTqUUhV9WX3kDD7A.png" /></figure><p>The main purpose is to show that we can organize our Spark pipeline with an Object-Oriented Programming structure that could be a sophisticated way to embed a pipeline in our data engineering projects.</p><p>I’m going to write the complete class code down here for you to try in your Jupyter Notebook/Lab.</p><p>Check this project in my Kaggle account:</p><p><a href="https://www.kaggle.com/code/lucianosantos014513/medallion-architecture-pipeline-in-a-oop-structure">Medallion Architecture pipeline in a OOP structure</a></p><pre>import pandas as pd<br>import requests<br>from pyspark.sql import SparkSession<br>from pyspark.sql.functions import col<br><br>## The main variables used<br>url = &quot;https://api.openbrewerydb.org/breweries&quot;<br>path = &#39;/kaggle/working/breweries.csv&#39;<br><br>class BreweriesAPI:<br>    def __init__(self):<br>        ### Constructor method that creates a spark cluster<br>         self.spark = SparkSession.builder.appName(&quot;MeuDataFrame&quot;).master(&quot;local[*]&quot;).getOrCreate()<br>        <br>    def get_data_from_api(self,url):<br>         try:  # downloads the data from the API url<br>             response = requests.get(url)<br>             data = response.json()<br>             print(f&quot;Success while extracting data from {url}&quot;)<br>             return data<br>         except:<br>             print(f&quot;An ERROR ocurred while getting data from {url}&quot;)<br>         <br>    def create_csv_file(self,data,path):<br>          try: # creates a csv file in my directory from the data downloaded<br>              pandas_df = pd.DataFrame(data)<br>              pandas_df.to_csv(path,index=False)<br>              print(f&quot;Success while loading pandas dataframe from data object&quot;)<br>          except:<br>              print(f&quot;An ERROR occurred loading pandas dataframe from data object&quot;)<br><br>    def create_bronze_layer(self,path):<br>         try: # creates a dataframe with row data from the source.<br>              bronze_df = self.spark.read.csv(path,header=True)<br>              bronze_df = bronze_df.withColumn(&quot;address_3&quot;, col(&quot;address_3&quot;).cast(&quot;string&quot;))<br>              bronze_df.show(10)<br>              return bronze_df<br>         except:<br>              print(f&quot;An ERROR ocurred creating the BRONZE LAYER spark dataframe!&quot;)<br><br>    def create_silver_layer(self,bronze_df):<br>         try: # creates a dataframe with data cleansing and some business rules.<br>             silver_df = bronze_df.repartition(&#39;state_province&#39;,&#39;country&#39;)<br>             silver_df = silver_df.dropDuplicates()\<br>                .drop(&quot;address_2&quot;, &quot;address_3&quot;,&quot;state&quot;,&#39;id&#39;,&#39;postal_code&#39;,&#39;latitude&#39;,&#39;longitude&#39;,&#39;phone&#39;,&#39;state&#39;)\<br>                         .withColumnRenamed(&#39;address_1&#39;,&#39;address&#39;)\<br>                         .withColumnRenamed(&#39;brewery_type&#39;,&#39;type&#39;)<br>             silver_df.show(10)<br>             return silver_df<br>         except:<br>             print(f&quot;An ERROR ocurred creating the SILVER LAYER spark dataframe!&quot;)<br><br>    def create_gold_layer(self,silver_df):<br>          try: # creates a dataframe with a final aggregation for the presentation layer.<br>              gold_df = silver_df.select(&#39;type&#39;,&#39;state_province&#39;,&#39;country&#39;)\<br>                .groupBy(&#39;type&#39;,&#39;state_province&#39;,&#39;country&#39;).count().orderBy(&#39;count&#39;,ascending=False)<br>              gold_df.show(10)<br>          except: <br>              print(f&quot;An ERROR ocurred creating the GOLD LAYER spark dataframe!&quot;)<br><br><br># new Object instance<br>breweries = BreweriesAPI()<br><br># returns the data downloaded from the API url<br>data = breweries.get_data_from_api(url)<br><br># loads the csv file in the directory<br>breweries.create_csv_file(data,path)<br><br># returns the bronze layer dataframe<br>bronze_df = breweries.create_bronze_layer(path)<br><br># returns the silver layer dataframe<br>silver_df = breweries.create_silver_layer(bronze_df)<br><br># returns the gold layer dataframe<br>breweries.create_gold_layer(silver_df)</pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d3290ace29b4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Pandasql: Manipulating dataframes using SQL in Python.]]></title>
            <link>https://medium.com/@lucianosantosg3/pandasql-manipulating-dataframes-using-sql-in-python-ac7ea1362e9a?source=rss-eab6b9636e09------2</link>
            <guid isPermaLink="false">https://medium.com/p/ac7ea1362e9a</guid>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[data-engineering]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[technology]]></category>
            <dc:creator><![CDATA[Lucianosantosg]]></dc:creator>
            <pubDate>Thu, 20 Feb 2025 18:00:45 GMT</pubDate>
            <atom:updated>2026-05-18T14:22:47.974Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*VcADyAA8ppEllk_1.png" /></figure><p>Pandas lib is already awesome for data handling in Python. We can turn a dataset into a dataframe table and have all the data manipulation functions needed to perform the transformation. So, what else do we need in Python? There is another data manipulation tool in Python’s toolbox: the <strong><em>Pandasql</em></strong> library. What if we use SQL syntax to handle pandas dataframes, as if they were database tables? It looks even more awesome for data engineers.</p><p>I’m going to represent a star schema data model(dataframes as fact and dimension tables) using the example written in my previous article “Creating a star schema with Pandas Dataframes”, <strong>but manipulating the data just using SQL from the Pandasql library</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/834/1*roZ5xNMSbGmSyn_lbFtovw.png" /><figcaption>The star schema abstraction</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/347/1*QftVQgqqoRN0BwRk5cKx2Q.png" /></figure><p>Now, we are going to create the dimensions(product and client) and fact(fact_sales) dataframes:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/664/1*CcWPL7Q4kmCnEZXlsd1cmQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/623/1*XKTmHps18RAr8uF8OTtZig.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/731/1*M3e27qsbvbQVqhm6g3S-1g.png" /></figure><p>The next step is to join the fact dataframe with the dimensions altogether to create an enriched fact table in a single SQL query, invoking the <strong><em>sqldf </em></strong>function:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/551/1*NNJOT7t2Le6WrBX4UqxTVQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/468/1*VXJ27yVeAYrBADq5AF55IA.png" /></figure><p>Now, let’s create the sales per client analysis. The inner_table query aggregates the quantity and total values, grouping by the client name. Then we created a new column applying the client’s classification based on the amount of total value in a CASE WHEN structure:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/519/1*rSai9z1hXJecYfXldCLoFw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/311/1*QmqnkUiEe2ISnpXnFWWR3w.png" /></figure><p>Can you realize how complete <strong><em>Pandasdf’s</em></strong> SQL is? We just used a CTE structure to create a temporary table and a CASE WHEN statement. From my point of view, it’s amazing to have this kind of resource available in Python.</p><p>Lastly, we are going to create a single client purchase analysis, creating a total_cart value column:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/476/1*lcll2vkI-zOpBu1_sVUK0g.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/488/1*qvHJXYffuDmU-34q7zSXmg.png" /></figure><p>So, I hope using Pandasql SQL can help you in your data engineering projects. We could see that we can anticipate SQL transformation\analysis in Python’s notebook instead of doing this just in a database environment, usually the last step in a data integration pipeline.</p><p>I’m going to put all the code we used in this sample project, so I suggest you try it out in your Jupyter Lab/Notebook to see how it feels.</p><p>Please check a more detailed version of this project in my Kaggle portfolio:</p><p><a href="https://www.kaggle.com/code/lucianosantos014513/creating-a-star-schema-using-pandas-dataframes/edit">Creating a Star Schema using Pandas&#39; Dataframes</a></p><pre>import pandas as pd<br>from pandasql import sqldf<br><br>product = {&#39;cod_product&#39;:[1,2,3,4,5],<br>                &#39;product&#39;:[&#39;Biscuit&#39;,&#39;Chocolate&#39;,&#39;Fruits&#39;,&#39;Meat&#39;,&#39;Grains&#39;],<br>                &#39;price&#39;:[3,10,25,50,15]}<br>product_df = pd.DataFrame(product)<br>product_df<br><br>client = {&#39;cod_client&#39;:[1,2,3,4,5],<br>                &#39;client&#39;:[&#39;Luciano&#39;,&#39;Charles&#39;,&#39;Robert&#39;,&#39;Mary&#39;,&#39;Anna&#39;]}<br>client_df = pd.DataFrame(client)<br>client_df<br><br>fact_sales = {&#39;cod_sales&#39;:[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20],<br>               &#39;cod_client&#39;:[1,2,3,4,5,5,4,3,2,1,1,2,3,4,5,5,4,3,2,1],<br>                &#39;cod_product&#39;:[4,2,1,3,5,5,4,2,3,1,1,3,4,5,2,1,3,2,4,5],<br>                &#39;quantity&#39;: [3,4,5,2,1,1,5,2,4,3,1,3,4,5,2,4,1,5,2,3]}<br>fact_sales_df = pd.DataFrame(fact_sales)<br>fact_sales_df<br><br>query = &quot;&quot;&quot;<br><br>    SELECT f.cod_sales, <br>           c.client, <br>           p.product, <br>           p.price, <br>           f.quantity, <br>           p.price * f.quantity as total<br>    FROM fact_sales_df f<br>    INNER JOIN product_df p on p.cod_product = f.cod_product<br>    INNER JOIN client_df c  on c.cod_client =  f.cod_client<br><br>&quot;&quot;&quot;<br><br>enriched_fact_table = sqldf(query)<br>enriched_fact_table<br><br>query = &quot;&quot;&quot;<br><br>     WITH inner_table AS <br>      (<br>      SELECT client,<br>             SUM(quantity) as quantity,<br>             SUM(total) as total<br>      FROM enriched_fact_table<br>      GROUP BY client<br>     ) <br><br>   SELECT client, <br>          quantity,<br>          total,<br>          CASE <br>          WHEN total &gt;= 400 THEN &#39;Diamond&#39;<br>          WHEN total &lt; 400 AND total &gt;= 300 THEN &#39;Gold&#39;<br>          WHEN total &lt; 300 AND total &gt;= 250 THEN &#39;Silver&#39;<br>          WHEN total &lt; 250 AND total &gt;= 200 THEN &#39;Silver&#39;<br>          ELSE &#39;No Score&#39;<br>          END &#39;Classification&#39;<br>   FROM inner_table<br>   ORDER BY total DESC<br>   <br>&quot;&quot;&quot;<br><br>sales_per_client = sqldf(query)<br>sales_per_client<br><br>query = &quot;&quot;&quot;<br>  <br>  SELECT ft.cod_sales,ft.client,ft.product,ft.price, ft.quantity,ft.total,<br>   (<br>     SELECT sum(total) as cart_total<br>     FROM enriched_fact_table ft <br>     WHERE client = &#39;Luciano&#39; <br>   ) cart_total<br>  FROM enriched_fact_table ft <br>  WHERE client = &#39;Luciano&#39;<br>  ORDER BY total DESC<br><br>&quot;&quot;&quot;<br><br>single_client_sales = sqldf(query)<br>single_client_sales</pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ac7ea1362e9a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Creating a Star Schema with Pandas Dataframes]]></title>
            <link>https://medium.com/@lucianosantosg3/creating-a-star-schema-with-python-dataframes-05e84e7312ee?source=rss-eab6b9636e09------2</link>
            <guid isPermaLink="false">https://medium.com/p/05e84e7312ee</guid>
            <category><![CDATA[pandas]]></category>
            <category><![CDATA[dataframes]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[data-modeling]]></category>
            <dc:creator><![CDATA[Lucianosantosg]]></dc:creator>
            <pubDate>Tue, 07 Jan 2025 01:06:34 GMT</pubDate>
            <atom:updated>2026-05-18T14:17:34.491Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/770/1*pJnfAWcDbz7qnQr7at3jkw.png" /></figure><p>It’s usual to load pandas dataframes into our target database, just as a direct integration step, so start working on analysis in the SQL context. But, from my point of view, it’s an excellent exercise to represent a star schema in Python, connecting pandas dataframes and generating a single dataframe, as a business information-enriched fact table, where deeper analysis can be done. Using Python, we can anticipate data enrichment before loading it into the database and enhance insights using its resources compared with SQL capabilities.</p><p>I’m creating from scratch three dataframes as examples: two as dimensions (client and product) and one as a fact table (fact_sales):</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KlrT2bylYv4UP5k8gukzcw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/338/1*tAtoNCg7aVWc88EWcd3O1A.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/622/1*yvUeQOMyFr3Ru5PgAqJKcQ.png" /><figcaption>product dataframe</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/550/1*kPU0ANqlNjLto4BaKbOO5A.png" /><figcaption>client dataframe</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/641/1*xl-MnrgjLEbal_4l4cNnDg.png" /><figcaption>fact sales dataframe</figcaption></figure><p>The fact table has the foreign keys cod_client and cod_product for further joins with the dimensions. The two dimensions, product and client, have their code and description data, just as a star schema would look like. Now, we are going to join these tables using Pandas’ dataframe <strong><em>Merge </em></strong>function, simulating the INNER JOIN clause, and enrich the sales fact dataframe with description data from the dimensions:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/778/1*RlewjmFku05gjaXf3WEo6g.png" /></figure><p>We are creating the fact_sales_df_2 dataframe to hold the first enrichment, joining to the client_df by taking the client name. We’re dropping the cod_client column; it was just for the join purpose.</p><p>Let’s pay attention to the <strong><em>merge </em></strong>function parameters. The first is the dataframe’s name we want to join to. The second <strong><em>how </em></strong>represents the join modality: <strong><em>inner, left, or right. </em></strong>The third <strong><em>on </em></strong>represents the column to be joined, in this case, we got the same column names in both fact_sales_df and client_df (cod_client).</p><p>Now, let’s do more information enrichment by joining the fact_sales_df_2 to the product_df dataframe, creating the fact_sales_df_3:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/779/1*Jexy3SMBtypnulBO7QOfdQ.png" /></figure><p>Lastly, we are going to reorder the column positions:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/656/1*xMeOtIhvygBB4El6AE-RZA.png" /></figure><p>Creating a total purchase column, multiplying the quantity by the price to enrich even more:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/616/1*Sl2LSsYukH2XXFl9M2BVaQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/495/1*7YMFlsIPTPxk5tRz1EblRQ.png" /></figure><p>Let’s create a sales-per-client analysis, generating a dynamic column classification, using a function for it. We’re selecting the client, quantity, and total columns, grouping by the client, and sorting values by the total:</p><p>Note: the sort_values() function parameter <strong><em>ascending</em></strong> = <strong>False</strong> means the column total is going to have a descending order (if it were <strong>True</strong>, an <strong>ascending</strong> order)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/725/1*rzLzxfN1rvfnI8ysfIJe7w.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/405/1*Eo_qVmtJLB9EJ-qICBscMA.png" /><figcaption>total purchase classification function.</figcaption></figure><p>There is a way important pandas dataframe function called <strong><em>apply. </em></strong>We can apply rules to a determined column and create a new column from it. This classification function classifies the client level based on the amount of purchase:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/606/1*3SKQZh2iTxJWr3Zbh87lxg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/311/1*h4492FQwav-X_VliUTUnnw.png" /></figure><p>Finally, I’m filtering the dataframe to keep the purchase analysis from a specific client, and calculating the amount of purchase:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/682/1*YJCsrfjPgGbcdQOo8ILP7g.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/471/1*wUonmNqEsk7bb2DqnkYSXg.png" /></figure><p>To make a long story short, the main goal was to abstract a possible star schema joining dataframes and creating an enriched final fact table, using the Python <strong><em>merge</em></strong> function. Besides, how to use aggregate functions combining sum(), groupby(), and sort_values() to generate an analysis. Lastly, the important function <strong><em>apply() </em></strong>applies rules to a column, generating a new column with dynamic data.</p><p>The code used is written below. Try it yourself in your Jupyter Notebook/Lab.</p><p>Please check out a more detailed project version in my Kaggle portfolio:</p><p><a href="https://www.kaggle.com/code/lucianosantos014513/creating-a-star-schema-using-pandas-dataframes/edit">Creating a Star Schema using Pandas&#39; Dataframes</a></p><pre>import pandas as pd<br><br>product = {&#39;cod_product&#39;:[1,2,3,4,5],<br>                &#39;product&#39;:[&#39;Biscuit&#39;,&#39;Chocolate&#39;,&#39;Fruits&#39;,&#39;Meat&#39;,&#39;Grains&#39;],<br>                &#39;price&#39;:[3,10,25,50,15]}<br>product_df = pd.DataFrame(product)<br>product_df<br><br>client = {&#39;cod_client&#39;:[1,2,3,4,5],<br>                &#39;client&#39;:[&#39;Luciano&#39;,&#39;Charles&#39;,&#39;Robert&#39;,&#39;Mary&#39;,&#39;Anna&#39;]}<br>client_df = pd.DataFrame(client)<br>client_df<br><br>fact_sales = {&#39;cod_sales&#39;:[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20],<br>               &#39;cod_client&#39;:[1,2,3,4,5,5,4,3,2,1,1,2,3,4,5,5,4,3,2,1],<br>                &#39;cod_product&#39;:[4,2,1,3,5,5,4,2,3,1,1,3,4,5,2,1,3,2,4,5],<br>                &#39;quantity&#39;: [3,4,5,2,1,1,5,2,4,3,1,3,4,5,2,4,1,5,2,3]}<br>fact_sales_df = pd.DataFrame(fact_sales)<br>fact_sales_df<br><br>fact_sales_df_2 = fact_sales_df.merge(client_df,how=&#39;inner&#39;, on=&#39;cod_client&#39;).drop(columns=[&#39;cod_client&#39;])<br>fact_sales_df_2<br><br>fact_sales_df_3 = fact_sales_df_2.merge(product_df,how=&#39;inner&#39;,on=&#39;cod_product&#39;).drop(columns=&#39;cod_product&#39;)<br>fact_sales_df_3<br><br>fact_sales_df_3 = fact_sales_df_3[[&#39;cod_sales&#39;,&#39;client&#39;,&#39;product&#39;,&#39;price&#39;,&#39;quantity&#39;]]<br>fact_sales_df_3<br><br>fact_sales_df_3[&#39;total&#39;] = fact_sales_df_3[&#39;price&#39;] * fact_sales_df_3[&#39;quantity&#39;]<br>fact_sales_df_3<br><br>sales_per_client = fact_sales_df_3[[&#39;client&#39;,&#39;quantity&#39;,&#39;total&#39;]].\<br>    groupby(&#39;client&#39;).sum().sort_values(by=&#39;total&#39;,ascending=False).reset_index()<br>sales_per_client<br><br>def classification(total):<br>    if total &gt;= 400:<br>        return &#39;Diamond&#39;<br>    elif total &lt; 400 and total &gt;=300:<br>        return &#39;Gold&#39;<br>    elif total &lt; 300 and total &gt;=250:<br>        return &#39;Silver&#39;<br>    elif total &lt; 250 and total &gt;=200:<br>        return &#39;Bronze&#39;<br>    else:<br>        return &#39;No Score&#39;<br><br>sales_per_client[&#39;classification&#39;] = sales_per_client[&#39;total&#39;].apply(classification)<br><br>sales_per_client<br><br>luciano_purchase = fact_sales_df_3[fact_sales_df_3[&#39;client&#39;] == &#39;Luciano&#39;]<br>luciano_purchase[&#39;total_cart&#39;] =  sum(compras_luciano[&#39;total&#39;])<br><br>luciano_purchase<br><br><br></pre><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=05e84e7312ee" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Decoupling nested data in PySpark dataframes]]></title>
            <link>https://medium.com/@lucianosantosg3/decoupling-nested-data-in-pyspark-dataframes-3f1f778995c0?source=rss-eab6b9636e09------2</link>
            <guid isPermaLink="false">https://medium.com/p/3f1f778995c0</guid>
            <category><![CDATA[data-engineering]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[pyspark]]></category>
            <dc:creator><![CDATA[Lucianosantosg]]></dc:creator>
            <pubDate>Tue, 03 Dec 2024 18:46:03 GMT</pubDate>
            <atom:updated>2026-05-18T14:25:11.557Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*Z4-dDRydD8Kx7-EyoKCUtw.jpeg" /></figure><p>I suppose this is a frequent challenge for data engineers working with PySpark. Many times I got a dataframe with a column with a list data type, or, even worse, a long string column with a lot of substrings separated by characters like commas, semicolons, pipes, and so on…</p><p>The goal here is to decouple this kind of data to isolate each value from the column list and promote the repetition of the row by the number of values in that list. This will allow us to work properly with aggregate functions and grouping, and provide a cleaner data view and analysis. Besides, it helps the denormalization process for creating dimension and fact tables in a data warehouse project.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/753/1*y7Js81XqW36rjHPDE0d_Kw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1020/1*5Cib_dNuT4fdNhQ6yizZaQ.png" /><figcaption>Location file uploading from my C driver</figcaption></figure><p>First, using the Jupyter Notebook/Lab, we import the libs that we are going to use: the main SparkSession. The additional functions set: explode, split, size, and monotonically_increasing_id. We are creating the Spark session and then importing the CSV file through spark.read_csv function.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FyVUMXiUpcplB6YCQTu7lA.png" /></figure><p>This is a sample dataframe from the locations file. We can see that there are many vaccine types in a row for a location. This problem means that we can’t work with the vaccine information properly, and it is going to prevent us from using the vaccine data more analytically. First, we are going to split this vaccine string into single vaccine values in a list. So, we are going to use the split function and write this line of code below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/697/1*1YAjiyEJE1zEwPFJVuPOOQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1012/1*_sJ7IlMHeik3fqMzAS7A1A.png" /></figure><p>The ‘withColumn’ function creates a new column, in theory. But I’m using the former name column because I wish to replace it, not an additional column. There is an inner function ‘split’. The first parameter means the data column, and the second parameter we inform the separation character ‘,’ (comma). As the vaccines column above, now, we have a list of vaccine types well separated in a list object. We can see it by the square brackets at the beginning.</p><p>Next, we are going to create a new column using the ‘withColumn’ function again. As we have well-defined vaccine types in the list object, let’s create a column ‘vaccine_count’ to have a better idea of the number of vaccines there are listed in a single row.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/695/1*dOtTODYBq9L2JAID4h2UzQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*gwLDqzy5ahi-wiWCj2pjhQ.png" /></figure><p>We can see that in the first row (Afghanistan), we got 10 different types of vaccines. This is going to be important data to compare with our final result.</p><p>Now, we are going to turn it better, let’s explode these lists into single string values, repeating the row by the number of single vaccines found in the list object:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/755/1*tAxMU9WPC4Gev0kbDorVjg.png" /></figure><p>Creating a new dataframe named ‘locations_split_vaccines’, using the ‘select’ function, like in the SQL statement, we are listing the columns. But, with the vaccines column, we are going to use an inner function, ‘explode’. This function will decouple every vaccine value from the list. This whole statement is going to repeat that row for each vaccine type, decoupled from the list.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/967/1*kctbYkrrrfw5-MOJGd84wg.png" /></figure><p>Now, I’m adding a new column using the ‘withColumn’ function with an inner function ‘monotonically_increasing_id’ plus 1 to create a ‘row_number ’ column, starting to count from number one. The new dataframe result is this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*2LFx4TDYjk7C6fUah_aAqg.png" /></figure><p>As the count we have in the ‘vaccine_count’ column, the first row, Afghanistan location, had 10 different types of vaccines. That row was duplicated by the 10 types of vaccines found in the former list. Now, data analysis has become easier with aggregation and grouping functions. Decoupling data works as a denormalizing process for dimensions and fact tables development.</p><p>Now that we can create an analysis of the vaccine data, we are going to generate a sample of the top ten most used vaccines, using ‘groupBy’, ‘count’, and ‘orderBy’ descending:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/776/1*c1rMFY68st5SVZuF0a2QSA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/262/1*31GSiEfcqs8Cgy3inlvkqA.png" /></figure><p>So, that was a very simple analysis that you will be able to work on. Now, it is up to you how you will adapt this to your integration projects.</p><p>If this article is useful to you, please don’t forget to like this page, so it will make this article more visible to Medium members.</p><p>Here is the PySpark code we worked on:</p><pre>from pyspark.sql import SparkSession<br>from pyspark.sql.functions import explode, split, size, monotonically_increasing_id<br><br>spark = SparkSession.builder.appName(&quot;MeuDataFrame&quot;).getOrCreate()<br><br>locations = spark.read.csv(&#39;your_path\locations.csv&#39;, header=True, inferSchema=True)<br><br>locations.show()<br><br>locations = locations.withColumn(&#39;vaccines&#39;,split(locations[&quot;vaccines&quot;],&quot;,&quot;))<br><br>locations.show()<br><br>locations = locations.withColumn(&#39;vaccine_count&#39;,size(locations[&#39;vaccines&#39;]))<br><br>locations.show()<br><br>locations_split_vaccines = locations.select(<br>    &quot;location&quot;,<br>    &quot;iso_code&quot;,<br>    explode(locations[&quot;vaccines&quot;]).alias(&quot;vaccine&quot;),  # Explode the vaccines column<br>    &quot;last_observation_date&quot;,<br>    &quot;source_name&quot;,<br>    &quot;source_website&quot;,<br>    &quot;vaccine_count&quot;<br>)<br><br>locations_split_vaccines = locations_split_vaccines.withColumn(&#39;row_number&#39;,monotonically_increasing_id()+1)<br><br>locations_split_vaccines.show()<br><br>vaccine_top_10 = locations_split_vaccines.select(&#39;vaccine&#39;).groupBy(&#39;vaccine&#39;).count()<br>vaccine_top_10 = vaccine_top_10.orderBy(&#39;count&#39;,ascending=False).limit(10)<br><br>vaccine_top_10.show()</pre><p>You can create the locations.csv file from the content below:</p><pre>location,iso_code,vaccines,last_observation_date,source_name,source_website<br>Afghanistan,AFG,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-12-31,World Health Organization,https://data.who.int/dashboards/covid19/<br>Albania,ALB,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac, Sputnik V&quot;,2023-09-10,World Health Organization,https://data.who.int/dashboards/covid19/<br>Algeria,DZA,&quot;Oxford/AstraZeneca, Sinopharm/Beijing, Sinovac, Sputnik V&quot;,2022-09-04,World Health Organization,https://data.who.int/dashboards/covid19/<br>Andorra,AND,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-09-24,World Health Organization,https://data.who.int/dashboards/covid19/<br>Angola,AGO,Oxford/AstraZeneca,2023-12-31,World Health Organization,https://data.who.int/dashboards/covid19/<br>Anguilla,AIA,&quot;Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-03-17,World Health Organization,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Antigua and Barbuda,ATG,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2022-09-16,Ministry of Health,https://covid19.who.int/<br>Argentina,ARG,&quot;CanSino, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2024-01-27,Ministry of Health,https://covidstats.com.ar/<br>Armenia,ARM,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinopharm/Wuhan, Sinovac, Sputnik Light, Sputnik V&quot;,2023-10-01,World Health Organization,https://data.who.int/dashboards/covid19/<br>Aruba,ABW,Pfizer/BioNTech,2024-03-12,Government of Aruba,https://www.government.aw<br>Australia,AUS,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-12-31,Government of Australia via CovidBaseAU,https://data.who.int/dashboards/covid19/<br>Austria,AUT,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech, Sanofi/GSK, Valneva&quot;,2023-06-30,European CDC,https://www.ecdc.europa.eu/en/publications-data/data-covid-19-vaccination-eu-eea<br>Azerbaijan,AZE,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac, Sputnik V&quot;,2022-08-28,Government of Azerbaijan,https://koronavirusinfo.az<br>Bahamas,BHS,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-05-12,Pan American Health Organization,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Bahrain,BHR,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2022-12-21,Ministry of Health,https://data.who.int/dashboards/covid19/<br>Bangladesh,BGD,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac&quot;,2024-07-02,Directorate General of Health Services,http://103.247.238.92/webportal/pages/covid19-vaccination-update.php<br>Barbados,BRB,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2023-12-29,Ministry of Health,https://data.who.int/dashboards/covid19/<br>Belarus,BLR,&quot;KoviVac/Chumakov, Sinopharm/Beijing, Sputnik Light, Sputnik V&quot;,2023-09-03,World Health Organization,https://data.who.int/dashboards/covid19/<br>Belgium,BEL,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2024-02-11,Sciensano,https://epistat.wiv-isp.be/covid/<br>Belize,BLZ,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2023-05-12,World Health Organization,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Benin,BEN,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2022-12-18,Ministry of Health,https://data.who.int/dashboards/covid19/<br>Bermuda,BMU,&quot;Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2022-07-08,Pan American Health Organization,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Bhutan,BTN,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2022-10-30,World Health Organization,https://data.who.int/dashboards/covid19/<br>Bolivia,BOL,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2022-10-07,Ministry of Health via https://www.boligrafica.com/,https://github.com/dquintani/vacunacion/<br>Bonaire Sint Eustatius and Saba,BES,&quot;Moderna, Pfizer/BioNTech&quot;,2021-09-01,World Health Organization,https://www.rivm.nl/sites/default/files/2021-09/COVID-19_website_rapport_eilanden_engels_35_20210902_1409.pdf<br>Bosnia and Herzegovina,BIH,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac, Sputnik V&quot;,2022-01-29,World Health Organization,https://data.who.int/dashboards/covid19/<br>Botswana,BWA,&quot;Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2023-12-31,Africa Centres for Disease Control and Prevention,https://data.who.int/dashboards/covid19/<br>Brazil,BRA,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2023-03-22,State governments via coronavirusbra1.github.io,https://coronavirusbra1.github.io<br>British Virgin Islands,VGB,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca&quot;,2022-09-16,World Health Organization,https://covid19.who.int/<br>Brunei,BRN,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2023-06-30,World Health Organization,https://data.who.int/dashboards/covid19/<br>Bulgaria,BGR,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2024-06-29,Ministry of Health,https://coronavirus.bg/bg/statistika<br>Burkina Faso,BFA,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-07-23,World Health Organization,https://data.who.int/dashboards/covid19/<br>Burundi,BDI,&quot;Johnson&amp;Johnson, Sinopharm/Beijing&quot;,2023-12-31,World Health Organization,https://data.who.int/dashboards/covid19/<br>Cambodia,KHM,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac&quot;,2023-12-31,World Health Organization,https://data.who.int/dashboards/covid19/<br>Cameroon,CMR,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2023-10-15,World Health Organization,https://data.who.int/dashboards/covid19/<br>Canada,CAN,&quot;Johnson&amp;Johnson, Medicago, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2024-07-24,Official data from provinces via covid19tracker.ca,https://covid19tracker.ca/vaccinationtracker.html<br>Cape Verde,CPV,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2022-09-25,World Health Organization,https://data.who.int/dashboards/covid19/<br>Cayman Islands,CYM,&quot;Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-12-29,World Health Organization,https://data.who.int/dashboards/covid19/<br>Central African Republic,CAF,&quot;Covaxin, Oxford/AstraZeneca&quot;,2023-09-03,Africa Centres for Disease Control and Prevention,https://data.who.int/dashboards/covid19/<br>Chad,TCD,Sinopharm/Beijing,2023-12-31,Africa Centres for Disease Control and Prevention,https://data.who.int/dashboards/covid19/<br>Chile,CHL,&quot;CanSino, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2023-12-29,&quot;Ministry of Health, via Ministry of Science GitHub repository&quot;,https://data.who.int/dashboards/covid19/<br>China,CHN,&quot;CanSino, IMBCAMS, KCONVAC, Sinopharm/Beijing, Sinopharm/Wuhan, Sinovac, ZF2001&quot;,2023-02-09,National Health Commission,https://www.chinacdc.cn/jkzt/crb/zl/szkb_11803/jszl_13141/202302/t20230211_263697.html<br>Colombia,COL,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2023-12-29,World Health Organization,https://data.who.int/dashboards/covid19/<br>Comoros,COM,&quot;Covaxin, Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2022-10-02,World Health Organization,https://data.who.int/dashboards/covid19/<br>Congo,COG,&quot;Moderna, Oxford/AstraZeneca, Sinopharm/Beijing, Sputnik V&quot;,2022-07-31,Africa Centres for Disease Control and Prevention,https://data.who.int/dashboards/covid19/<br>Cook Islands,COK,Pfizer/BioNTech,2023-02-13,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Costa Rica,CRI,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-10-06,Costa Rican Social Security Fund,https://data.who.int/dashboards/covid19/<br>Cote d&#39;Ivoire,CIV,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2023-02-19,World Health Organization,https://covid19.who.int/<br>Croatia,HRV,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-11-28,Ministry of Health,https://www.koronavirus.hr<br>Cuba,CUB,&quot;Abdala, Soberana Plus, Soberana02&quot;,2024-04-12,Ministry of Health,https://salud.msp.gob.cu/actualizacion-de-la-vacunacion-en-el-marco-de-los-estudios-de-los-candidatos-vacunales-cubanos-y-la-intervencion-sanitaria/<br>Curacao,CUW,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-05-12,Government of Curacao,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Cyprus,CYP,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-02-22,Ministry of Health,https://www.moh.gov.cy/moh/moh.nsf/All/0EFA027144C9E54AC22586BE0032B2F5<br>Czechia,CZE,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2024-07-31,Ministry of Health,https://onemocneni-aktualne.mzcr.cz/covid-19<br>Democratic Republic of Congo,COD,Oxford/AstraZeneca,2023-06-04,World Health Organization,https://data.who.int/dashboards/covid19/<br>Denmark,DNK,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-09-29,Statens Serum Institute,https://www.ecdc.europa.eu/en/publications-data/data-covid-19-vaccination-eu-eea<br>Djibouti,DJI,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-10-08,World Health Organization,https://data.who.int/dashboards/covid19/<br>Dominica,DMA,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2022-10-07,Pan American Health Organization,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Dominican Republic,DOM,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac&quot;,2023-12-28,Ministry of Public Health,https://vacunate.gob.do<br>Ecuador,ECU,&quot;CanSino, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2023-03-31,Government of Ecuador via Ecuacovid,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Egypt,EGY,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-05-21,World Health Organization,https://data.who.int/dashboards/covid19/<br>El Salvador,SLV,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac&quot;,2022-10-02,Ministry of Health,https://covid19.gob.sv/<br>England,OWID_ENG,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-07-10,Government of the United Kingdom,https://coronavirus.data.gov.uk/details/vaccinations<br>Equatorial Guinea,GNQ,&quot;Sinopharm/Beijing, Sinovac&quot;,2022-07-24,World Health Organization,https://data.who.int/dashboards/covid19/<br>Estonia,EST,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2024-08-12,National Health Board,https://opendata.digilugu.ee<br>Eswatini,SWZ,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-06-04,World Health Organization,https://data.who.int/dashboards/covid19/<br>Ethiopia,ETH,&quot;Covaxin, Johnson&amp;Johnson, Oxford/AstraZeneca, Sinopharm/Beijing, Sinovac&quot;,2023-05-28,World Health Organization,https://data.who.int/dashboards/covid19/<br>Faeroe Islands,FRO,&quot;Moderna, Pfizer/BioNTech&quot;,2022-02-18,Government of the Faeroe Islands,https://corona.fo/api<br>Falkland Islands,FLK,Oxford/AstraZeneca,2021-04-14,Government of the Falkland Islands,https://www.facebook.com/FalkIandsGov/posts/4401230323224594<br>Fiji,FJI,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-05-01,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Finland,FIN,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2024-01-09,Finnish Institute for Health and Welfare,https://sampo.thl.fi/pivot/prod/en/vaccreg/cov19cov/fact_cov19cov<br>France,FRA,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech, Sanofi/GSK&quot;,2023-07-10,Public Health France,https://www.data.gouv.fr/fr/datasets/donnees-relatives-aux-personnes-vaccinees-contre-la-covid-19-1/<br>French Polynesia,PYF,&quot;Johnson&amp;Johnson, Pfizer/BioNTech&quot;,2023-05-01,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Gabon,GAB,&quot;Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2023-02-05,Africa Centres for Disease Control and Prevention,https://data.who.int/dashboards/covid19/<br>Gambia,GMB,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-03-19,Africa Centres for Disease Control and Prevention,https://data.who.int/dashboards/covid19/<br>Georgia,GEO,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac&quot;,2022-10-13,National Center for Disease Control and Public Health,https://vaccines.ncdc.ge/vaccinationprocess/<br>Germany,DEU,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech, Valneva&quot;,2023-04-07,Robert Koch Institut,https://impfdashboard.de/<br>Ghana,GHA,&quot;Oxford/AstraZeneca, Sputnik V&quot;,2023-07-02,World Health Organization,https://data.who.int/dashboards/covid19/<br>Gibraltar,GIB,&quot;Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2022-12-16,Government of Gibraltar,https://twitter.com/GibraltarGov/status/1517138573614477315<br>Greece,GRC,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2024-06-26,Ministry of Health,https://www.data.gov.gr/datasets/mdg_emvolio/<br>Greenland,GRL,Moderna,2022-03-14,Government of Greenland,https://corona.nun.gl/en/<br>Grenada,GRD,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-03-17,World Health Organization,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Guatemala,GTM,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sputnik V&quot;,2023-05-12,Ministry of Health,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Guernsey,GGY,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2022-12-19,Government of Guernsey,https://covid19.gov.gg/guidance/vaccine/stats<br>Guinea,GIN,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik V&quot;,2023-09-24,National Health Security Agency,https://data.who.int/dashboards/covid19/<br>Guinea-Bissau,GNB,&quot;Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-10-15,World Health Organization,https://data.who.int/dashboards/covid19/<br>Guyana,GUY,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2023-02-17,Ministry of Health,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Haiti,HTI,&quot;Johnson&amp;Johnson, Moderna&quot;,2023-12-29,World Health Organization,https://data.who.int/dashboards/covid19/<br>Honduras,HND,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sputnik V&quot;,2023-08-11,World Health Organization,https://data.who.int/dashboards/covid19/<br>Hong Kong,HKG,&quot;Pfizer/BioNTech, Sinovac&quot;,2024-08-10,Food and Health Bureau,https://data.gov.hk/en-data/dataset/hk-dh-chpsebcddr-novel-infectious-agent<br>Hungary,HUN,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2022-12-27,Government of Hungary,https://koronavirus.gov.hu//cikkek/6-millio-421-ezer-beoltott-4-397-az-uj-fertozott-es-elhunyt-56-beteg<br>Iceland,ISL,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2022-03-29,Directorate of Health,https://www.covid.is/tolulegar-upplysingar-boluefni<br>India,IND,&quot;Corbevax, Covaxin, Novavax, Oxford/AstraZeneca, Sputnik V&quot;,2024-08-12,Government of India,https://dashboard.cowin.gov.in/<br>Indonesia,IDN,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac&quot;,2023-11-23,Government of Indonesia,https://data.who.int/dashboards/covid19/<br>Iran,IRN,&quot;COVIran Barekat, CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Soberana02, Sputnik Light, Sputnik V&quot;,2023-11-26,World Health Organization,https://data.who.int/dashboards/covid19/<br>Iraq,IRQ,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-01-02,World Health Organization,https://data.who.int/dashboards/covid19/<br>Ireland,IRL,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2024-05-10,Heath Service Executive,https://covid19ireland-geohive.hub.arcgis.com/<br>Isle of Man,IMN,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2022-06-23,Isle of Man Government,https://covid19.gov.im/general-information/covid-19-vaccination-statistics/<br>Israel,ISR,&quot;Moderna, Pfizer/BioNTech&quot;,2023-05-04,Government of Israel,https://datadashboard.health.gov.il/COVID-19/general<br>Italy,ITA,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech, Sanofi/GSK&quot;,2023-11-16,Extraordinary commissioner for the Covid-19 emergency,https://raw.githubusercontent.com/italia/covid19-opendata-vaccini/master/dati/somministrazioni-vaccini-latest.csv<br>Jamaica,JAM,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-10-03,Ministry of Health,https://vaccination.moh.gov.jm<br>Japan,JPN,&quot;Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-05-07,Prime Minister&#39;s Office,https://www.kantei.go.jp/jp/headline/kansensho/vaccine.html<br>Jersey,JEY,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-01-29,Government of Jersey,https://www.gov.je/Datasets/ListOpenData?ListName=COVID19Weekly&amp;clean=true<br>Jordan,JOR,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2022-08-21,World Health Organization,https://data.who.int/dashboards/covid19/<br>Kazakhstan,KAZ,&quot;Pfizer/BioNTech, QazVac, Sinopharm/Beijing, Sinovac, Sputnik V&quot;,2023-04-30,Government of Kazakhstan,https://data.who.int/dashboards/covid19/<br>Kenya,KEN,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2023-04-02,World Health Organization,https://data.who.int/dashboards/covid19/<br>Kiribati,KIR,Oxford/AstraZeneca,2023-02-20,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Kosovo,OWID_KOS,&quot;Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-02-12,Ministry of Health,https://msh.rks-gov.net/sq/statistikat-covid-19/<br>Kuwait,KWT,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-11-26,World Health Organization,https://data.who.int/dashboards/covid19/<br>Kyrgyzstan,KGZ,&quot;Sinopharm/Beijing, Sputnik V&quot;,2023-09-08,Ministry of Health,https://vc.emed.gov.kg/<br>Laos,LAO,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2022-08-11,World Health Organization,https://www.covid19.gov.la/index.php<br>Latvia,LVA,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2022-07-11,National Health Service,https://data.gov.lv/dati/eng/dataset/covid19-vakcinacijas<br>Lebanon,LBN,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2022-12-22,World Health Organization,https://data.who.int/dashboards/covid19/<br>Lesotho,LSO,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-03-19,World Health Organization,https://data.who.int/dashboards/covid19/<br>Liberia,LBR,Oxford/AstraZeneca,2022-12-11,World Health Organization,https://data.who.int/dashboards/covid19/<br>Libya,LBY,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-01-16,World Health Organization,https://data.who.int/dashboards/covid19/<br>Liechtenstein,LIE,&quot;Johnson&amp;Johnson, Moderna, Novavax, Pfizer/BioNTech&quot;,2023-06-07,Federal Office of Public Health,https://opendata.swiss/en/dataset/covid-19-schweiz?detGeo=FL<br>Lithuania,LTU,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2024-08-14,Ministry of Health,https://experience.arcgis.com/experience/cab84dcfe0464c2a8050a78f817924ca/page/page_3/<br>Luxembourg,LUX,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-06-11,Government of Luxembourg,https://covid19.who.int/<br>Macao,MAC,&quot;Pfizer/BioNTech, Sinopharm/Beijing&quot;,2023-04-13,Government of Macao,https://www.ssm.gov.mo/apps1/COVID19Case/en.aspx<br>Madagascar,MDG,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-07-30,World Health Organization,https://data.who.int/dashboards/covid19/<br>Malawi,MWI,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca&quot;,2023-09-24,World Health Organization,https://data.who.int/dashboards/covid19/<br>Malaysia,MYS,&quot;CanSino, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac&quot;,2024-08-14,Government of Malaysia,https://github.com/MoH-Malaysia/covid19-public<br>Maldives,MDV,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik V&quot;,2023-05-25,World Health Organization,https://data.who.int/dashboards/covid19/<br>Mali,MLI,Oxford/AstraZeneca,2023-05-14,World Health Organization,https://data.who.int/dashboards/covid19/<br>Malta,MLT,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2024-03-19,COVID-19 Malta Public Health Response Team,https://github.com/COVID19-Malta/COVID19-Cases<br>Mauritania,MRT,&quot;Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-11-19,Africa Centres for Disease Control and Prevention,https://data.who.int/dashboards/covid19/<br>Mauritius,MUS,&quot;Covaxin, Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-07-30,World Health Organization,https://data.who.int/dashboards/covid19/<br>Mexico,MEX,&quot;CanSino, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac, Sputnik V&quot;,2022-11-18,World Health Organization,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Moldova,MDA,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik V&quot;,2023-12-23,Ministry of Health,https://data.who.int/dashboards/covid19/<br>Monaco,MCO,Pfizer/BioNTech,2021-12-21,National Council,https://en.gouv.mc/Policy-Practice/Social-Affairs-and-Health/News/Minister-of-State-visits-those-working-to-combat-COVID<br>Mongolia,MNG,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2022-05-18,Ministry of Health via ikon.mn,https://ikon.mn/<br>Montenegro,MNE,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2022-08-26,Government of Montenegro,https://www.covidodgovor.me/<br>Montserrat,MSR,Oxford/AstraZeneca,2022-12-16,World Health Organization,https://covid19.who.int/<br>Morocco,MAR,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-05-14,World Health Organization,https://data.who.int/dashboards/covid19/<br>Mozambique,MOZ,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-07-02,World Health Organization,https://data.who.int/dashboards/covid19/<br>Myanmar,MMR,&quot;Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-08-21,World Health Organization,https://data.who.int/dashboards/covid19/<br>Namibia,NAM,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2023-11-12,Africa Centres for Disease Control and Prevention,https://data.who.int/dashboards/covid19/<br>Nauru,NRU,Oxford/AstraZeneca,2023-02-20,World Health Organization,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Nepal,NPL,&quot;Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2023-11-23,World Health Organization,https://data.who.int/dashboards/covid19/<br>Netherlands,NLD,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-09-29,&quot;European CDC, via Marino van Zelst&quot;,https://www.ecdc.europa.eu/en/publications-data/data-covid-19-vaccination-eu-eea<br>New Caledonia,NCL,Pfizer/BioNTech,2023-05-09,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>New Zealand,NZL,&quot;Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2024-08-11,Ministry of Health,https://www.tewhatuora.govt.nz/our-health-system/data-and-statistics/covid-vaccine-data<br>Nicaragua,NIC,&quot;Abdala, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Soberana02, Sputnik Light, Sputnik V&quot;,2023-08-11,World Health Organization,https://data.who.int/dashboards/covid19/<br>Niger,NER,&quot;Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-07-30,World Health Organization,https://data.who.int/dashboards/covid19/<br>Nigeria,NGA,Oxford/AstraZeneca,2023-11-05,World Health Organization,https://data.who.int/dashboards/covid19/<br>Niue,NIU,Pfizer/BioNTech,2023-03-04,SPC Public Health Division,https://data.who.int/dashboards/covid19/<br>North Macedonia,MKD,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinopharm/Wuhan, Sinovac, Sputnik V&quot;,2023-05-07,World Health Organization,https://data.who.int/dashboards/covid19/<br>Northern Cyprus,OWID_CYN,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2022-12-06,Ministry of Health,https://asi.saglik.gov.ct.tr/<br>Northern Ireland,OWID_NIR,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-07-11,Government of the United Kingdom,https://coronavirus.data.gov.uk/details/vaccinations<br>Norway,NOR,&quot;Moderna, Pfizer/BioNTech&quot;,2022-11-13,Norwegian Institute of Public Health,https://github.com/folkehelseinstituttet/surveillance_data<br>Oman,OMN,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2022-10-25,World Health Organization,https://data.who.int/dashboards/covid19/<br>Pakistan,PAK,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-11-14,National Command and Operation Centre,https://data.who.int/dashboards/covid19/<br>Palestine,PSE,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2022-10-18,World Health Organization,https://covid19.who.int/<br>Panama,PAN,&quot;Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-05-12,Pan American Health Organization,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Papua New Guinea,PNG,Oxford/AstraZeneca,2023-05-01,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Paraguay,PRY,&quot;Covaxin, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik V&quot;,2023-05-12,Pan American Health Organization,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Peru,PER,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2023-12-10,Ministerio de Salud via github.com/jmcastagnetto/covid-19-peru-vacunas,https://www.datosabiertos.gob.pe/dataset/vacunacion<br>Philippines,PHL,&quot;Covaxin, Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-03-19,Department of Health via ABS-CBN Investigative and Research Group,https://data.who.int/dashboards/covid19/<br>Pitcairn,PCN,Oxford/AstraZeneca,2022-08-29,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Poland,POL,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-11-10,Ministry of Health,https://www.gov.pl/web/szczepimysie/raport-szczepien-przeciwko-covid-19<br>Portugal,PRT,&quot;Covaxin, Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech, Sanofi/GSK, Sinopharm/Beijing, Sinovac&quot;,2023-09-29,World Health Organization,https://www.ecdc.europa.eu/en/publications-data/data-covid-19-vaccination-eu-eea<br>Qatar,QAT,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-05-07,Ministry of Public Health,https://data.who.int/dashboards/covid19/<br>Romania,ROU,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-12-23,Government of Romania via datelazi.ro,https://data.who.int/dashboards/covid19/<br>Russia,RUS,&quot;EpiVacCorona, Sputnik V&quot;,2023-09-27,Official data from local governments via gogov.ru,https://gogov.ru/articles/covid-v-stats<br>Rwanda,RWA,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik V&quot;,2023-06-04,World Health Organization,https://data.who.int/dashboards/covid19/<br>Saint Helena,SHN,Oxford/AstraZeneca,2021-05-05,Government of Saint Helena,https://www.sainthelena.gov.sh/2021/news/preliminary-data-from-the-covid-19-vaccination-programme/<br>Saint Kitts and Nevis,KNA,&quot;Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2022-12-07,Pan American Health Organization,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Saint Lucia,LCA,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2022-12-02,Ministry of Health,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Saint Vincent and the Grenadines,VCT,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sputnik Light, Sputnik V&quot;,2023-04-21,World Health Organization,https://covid19.who.int/<br>Samoa,WSM,Oxford/AstraZeneca,2023-04-17,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>San Marino,SMR,&quot;Pfizer/BioNTech, Sputnik V&quot;,2022-05-22,World Health Organization,https://data.who.int/dashboards/covid19/<br>Sao Tome and Principe,STP,Oxford/AstraZeneca,2023-07-30,World Health Organization,https://data.who.int/dashboards/covid19/<br>Saudi Arabia,SAU,&quot;Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-04-25,Saudi Health Council,https://covid19.who.int/<br>Scotland,OWID_SCT,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2022-09-11,Government of the United Kingdom,https://coronavirus.data.gov.uk/details/vaccinations<br>Senegal,SEN,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-11-12,World Health Organization,https://data.who.int/dashboards/covid19/<br>Serbia,SRB,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2022-06-23,Government of Serbia,https://vakcinacija.gov.rs/<br>Seychelles,SYC,&quot;Oxford/AstraZeneca, Sinopharm/Beijing, Sputnik V&quot;,2023-04-09,World Health Organization,https://data.who.int/dashboards/covid19/<br>Sierra Leone,SLE,&quot;Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-07-30,World Health Organization,https://data.who.int/dashboards/covid19/<br>Singapore,SGP,&quot;Moderna, Novavax, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac&quot;,2023-01-31,Government of Singapore,https://data.gov.sg/dataset/covid-19-vaccination<br>Sint Maarten (Dutch part),SXM,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-03-31,World Health Organization,https://covid19.who.int/<br>Slovakia,SVK,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech, Sputnik V&quot;,2022-07-31,Ministry of Health,https://github.com/Institut-Zdravotnych-Analyz/covid19-data/raw/main/Vaccination/OpenData_Slovakia_Vaccination_AgeGroup_District.csv<br>Slovenia,SVN,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2022-07-06,National Institute of Public Health via covid-19.sledilnik.org,https://covid-19.sledilnik.org/sl/stats<br>Solomon Islands,SLB,Oxford/AstraZeneca,2022-10-31,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Somalia,SOM,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-07-25,World Health Organization,https://data.who.int/dashboards/covid19/<br>South Africa,ZAF,&quot;Johnson&amp;Johnson, Pfizer/BioNTech&quot;,2023-09-24,Ministry of Health,https://data.who.int/dashboards/covid19/<br>South Korea,KOR,&quot;Johnson&amp;Johnson, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-05-26,Korea Centers for Disease Control and Prevention,https://ncv.kdca.go.kr/<br>South Sudan,SSD,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca&quot;,2023-10-01,World Health Organization,https://data.who.int/dashboards/covid19/<br>Spain,ESP,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-05-24,Ministry of Health,https://www.sanidad.gob.es/profesionales/saludPublica/ccayes/alertasActual/nCov/documentos/Informe_Comunicacion_20230526.ods<br>Sri Lanka,LKA,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2022-10-30,Ministry of Health&#39;s Epidemiology Unit,https://data.who.int/dashboards/covid19/<br>Sudan,SDN,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-04-02,World Health Organization,https://data.who.int/dashboards/covid19/<br>Suriname,SUR,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2022-05-23,Government of Suriname,https://laatjevaccineren.sr/<br>Sweden,SWE,&quot;Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2024-02-26,Public Health Agency of Sweden,https://www.fohm.se/folkhalsorapportering-statistik/statistikdatabaser-och-visualisering/vaccinationsstatistik/statistik-for-vaccination-mot-covid-19/<br>Switzerland,CHE,&quot;Johnson&amp;Johnson, Moderna, Novavax, Pfizer/BioNTech&quot;,2023-07-03,Federal Office of Public Health,https://opendata.swiss/en/dataset/covid-19-schweiz?detGeo=CH<br>Syria,SYR,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-04-18,World Health Organization,https://data.who.int/dashboards/covid19/<br>Taiwan,TWN,&quot;Medigen, Moderna, Novavax, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-09-24,Taiwan Centers for Disease Control,https://www.cdc.gov.tw/Category/Page/9jFXNbCe-sFK9EImRRi2Og<br>Tajikistan,TJK,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac, Sputnik V&quot;,2023-12-23,World Health Organization,https://data.who.int/dashboards/covid19/<br>Tanzania,TZA,&quot;Johnson&amp;Johnson, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2023-03-12,World Health Organization,https://data.who.int/dashboards/covid19/<br>Thailand,THA,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac&quot;,2022-09-30,Government of Thailand,https://ddc.moph.go.th/covid19-dashboard/<br>Timor,TLS,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2023-11-22,World Health Organization,https://data.who.int/dashboards/covid19/<br>Togo,TGO,Oxford/AstraZeneca,2023-11-19,World Health Organization,https://data.who.int/dashboards/covid19/<br>Tokelau,TKL,Pfizer/BioNTech,2022-12-05,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Tonga,TON,Oxford/AstraZeneca,2023-04-11,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Trinidad and Tobago,TTO,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing&quot;,2022-09-21,Ministry of Health,https://services3.arcgis.com/x3I4DqUw3b3MfTwQ/arcgis/rest/services/service_7a519502598f492a9094fd0ad503cf80/FeatureServer/0/query<br>Tunisia,TUN,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-06-20,World Health Organization,https://data.who.int/dashboards/covid19/<br>Turkey,TUR,&quot;Pfizer/BioNTech, Sinovac, Turkovac&quot;,2022-11-22,COVID-19 Vaccine Information Platform,https://covid19asi.saglik.gov.tr/<br>Turkmenistan,TKM,&quot;EpiVacCorona, Oxford/AstraZeneca, QazVac, Sinopharm/Beijing, Sputnik V, ZF2001&quot;,2023-08-06,World Health Organization,https://data.who.int/dashboards/covid19/<br>Turks and Caicos Islands,TCA,Pfizer/BioNTech,2023-01-06,World Health Organization,https://covid19.who.int/<br>Tuvalu,TUV,Oxford/AstraZeneca,2023-02-01,World Health Organization,https://data.who.int/dashboards/covid19/<br>Uganda,UGA,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2023-05-28,World Health Organization,https://data.who.int/dashboards/covid19/<br>Ukraine,UKR,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2023-12-23,Ministry of Health,https://data.who.int/dashboards/covid19/<br>United Arab Emirates,ARE,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2022-06-20,National Emergency Crisis and Disaster Management Authority,https://covid19.who.int/<br>United Kingdom,GBR,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2022-09-11,Government of the United Kingdom,https://coronavirus.data.gov.uk/details/vaccinations<br>United States,USA,&quot;Johnson&amp;Johnson, Moderna, Novavax, Pfizer/BioNTech&quot;,2023-05-09,Centers for Disease Control and Prevention,https://data.cdc.gov/Vaccinations/COVID-19-Vaccination-Trends-in-the-United-States-N/rh2h-3yt2<br>Uruguay,URY,&quot;Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac&quot;,2023-11-13,Ministry of Health via vacuna.uy,https://monitor.uruguaysevacuna.gub.uy/<br>Uzbekistan,UZB,&quot;Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac, Sputnik Light, Sputnik V, ZF2001&quot;,2023-12-23,World Health Organization,https://data.who.int/dashboards/covid19/<br>Vanuatu,VUT,Oxford/AstraZeneca,2023-02-20,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Venezuela,VEN,&quot;Abdala, Sinopharm/Beijing, Sinovac, Soberana02, Sputnik Light, Sputnik V&quot;,2022-12-07,Pan American Health Organization,https://ais.paho.org/imm/IM_DosisAdmin-Vacunacion.asp<br>Vietnam,VNM,&quot;Abdala, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sputnik V&quot;,2023-06-30,World Health Organization,https://data.who.int/dashboards/covid19/<br>Wales,OWID_WLS,&quot;Moderna, Oxford/AstraZeneca, Pfizer/BioNTech&quot;,2023-06-30,Government of the United Kingdom,https://coronavirus.data.gov.uk/details/vaccinations<br>Wallis and Futuna,WLF,Moderna,2023-01-23,SPC Public Health Division,https://stats.pacificdata.org/vis?tm=covid&amp;pg=0&amp;df[ds]=SPC2&amp;df[id]=DF_COVID_VACCINATION&amp;df[ag]=SPC&amp;df[vs]=1.0<br>Yemen,YEM,&quot;CanSino, Covaxin, Johnson&amp;Johnson, Moderna, Oxford/AstraZeneca, Pfizer/BioNTech, Sinopharm/Beijing, Sinovac, Sputnik Light, Sputnik V&quot;,2023-12-10,World Health Organization,https://data.who.int/dashboards/covid19/<br>Zambia,ZMB,&quot;Johnson&amp;Johnson, Oxford/AstraZeneca, Sinopharm/Beijing&quot;,2023-06-25,Government of Zambia,https://data.who.int/dashboards/covid19/<br>Zimbabwe,ZWE,&quot;Oxford/AstraZeneca, Sinopharm/Beijing, Sinovac, Sputnik V&quot;,2022-10-09,Ministry of Health,https://www.arcgis.com/home/webmap/viewer.html?url=https://services9.arcgis.com/DnERH4rcjw7NU6lv/ArcGIS/rest/services/Vaccine_Distribution_Program/FeatureServer&amp;source=sd</pre><p>These integration codes were written in Jupyter Lab and placed in the Anaconda development package. There are many IDEs for Python development, like Jupyter Lab/Notebook, Spyder, PyCharm, and more utilities. The link is below:</p><p><a href="https://www.anaconda.com/download">Download Anaconda Distribution | Anaconda</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3f1f778995c0" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>