<?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 Moustache Data - Mateusz Wąsalski on Medium]]></title>
        <description><![CDATA[Stories by Moustache Data - Mateusz Wąsalski on Medium]]></description>
        <link>https://medium.com/@m.wasalski?source=rss-631df0a86316------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*B6RICvrAjU2EBUmoLJf1Bg.png</url>
            <title>Stories by Moustache Data - Mateusz Wąsalski on Medium</title>
            <link>https://medium.com/@m.wasalski?source=rss-631df0a86316------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 05:53:28 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@m.wasalski/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[Road to Senior Data Engineer p.5]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">Hello awesome Mediumers!</p><p class="medium-feed-link"><a href="https://medium.com/@m.wasalski/road-to-senior-data-engineer-p-5-2d79d333445f?source=rss-631df0a86316------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@m.wasalski/road-to-senior-data-engineer-p-5-2d79d333445f?source=rss-631df0a86316------2</link>
            <guid isPermaLink="false">https://medium.com/p/2d79d333445f</guid>
            <dc:creator><![CDATA[Moustache Data - Mateusz Wąsalski]]></dc:creator>
            <pubDate>Wed, 04 Mar 2026 17:09:58 GMT</pubDate>
            <atom:updated>2026-03-04T17:09:58.718Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Road to Senior Data Engineer p.4]]></title>
            <link>https://medium.com/@m.wasalski/road-to-senior-data-engineer-p-4-802a163fb2dd?source=rss-631df0a86316------2</link>
            <guid isPermaLink="false">https://medium.com/p/802a163fb2dd</guid>
            <dc:creator><![CDATA[Moustache Data - Mateusz Wąsalski]]></dc:creator>
            <pubDate>Mon, 02 Mar 2026 21:47:07 GMT</pubDate>
            <atom:updated>2026-03-02T21:47:07.525Z</atom:updated>
            <content:encoded><![CDATA[<p>Hello awesome Mediumers!</p><p>After some personal ups and downs I wanted to get back to writing, so here I am. Hopefully it will help at least one of you :)</p><ol><li><strong><em>Certificatioins</em>:</strong> Preparing myself for Databricks Data Engineer Associate. Videos provided by Databricks via their academy are super helpfull. Definitely you need to check them out if you want to get some solid knowledge.</li><li><strong><em>Databricks</em>: </strong>Even though system we have built is fully functional I wanted to dive deep into what Databricks offers and since I know how it all works (not from tutorials) I know what are the pain points (at least for me) so I’m reading more about TBLProperties. Starting point for you if you want to check:</li></ol><p><a href="https://learn.microsoft.com/en-us/azure/databricks/delta/delta-change-data-feed">https://learn.microsoft.com/en-us/azure/databricks/delta/delta-change-data-feed</a></p><p>See you in the next episode!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=802a163fb2dd" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Road to Senior Data Engineer p.3]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">Hello awesome Mediumers!</p><p class="medium-feed-link"><a href="https://medium.com/@m.wasalski/road-to-senior-data-engineer-p-3-dd9d00e057b8?source=rss-631df0a86316------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@m.wasalski/road-to-senior-data-engineer-p-3-dd9d00e057b8?source=rss-631df0a86316------2</link>
            <guid isPermaLink="false">https://medium.com/p/dd9d00e057b8</guid>
            <dc:creator><![CDATA[Moustache Data - Mateusz Wąsalski]]></dc:creator>
            <pubDate>Thu, 20 Nov 2025 08:21:23 GMT</pubDate>
            <atom:updated>2025-11-20T08:21:23.677Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Road to Senior Data Engineer p.2]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">Hello awesome Mediumers!</p><p class="medium-feed-link"><a href="https://medium.com/@m.wasalski/road-to-senior-data-engineer-p-2-365220bb182d?source=rss-631df0a86316------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@m.wasalski/road-to-senior-data-engineer-p-2-365220bb182d?source=rss-631df0a86316------2</link>
            <guid isPermaLink="false">https://medium.com/p/365220bb182d</guid>
            <dc:creator><![CDATA[Moustache Data - Mateusz Wąsalski]]></dc:creator>
            <pubDate>Fri, 14 Nov 2025 22:40:13 GMT</pubDate>
            <atom:updated>2025-11-14T22:40:13.150Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Road to Senior Data Engineer p.1]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">Hello awesome Mediumers!</p><p class="medium-feed-link"><a href="https://medium.com/@m.wasalski/road-to-senior-data-engineer-p-1-ca05346eb0e0?source=rss-631df0a86316------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@m.wasalski/road-to-senior-data-engineer-p-1-ca05346eb0e0?source=rss-631df0a86316------2</link>
            <guid isPermaLink="false">https://medium.com/p/ca05346eb0e0</guid>
            <dc:creator><![CDATA[Moustache Data - Mateusz Wąsalski]]></dc:creator>
            <pubDate>Tue, 11 Nov 2025 23:21:58 GMT</pubDate>
            <atom:updated>2025-11-11T23:21:58.879Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Road to Senior: kickoff]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">Hello awesome Mediumers!</p><p class="medium-feed-link"><a href="https://medium.com/@m.wasalski/road-to-senior-kickoff-dca2ef83c670?source=rss-631df0a86316------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@m.wasalski/road-to-senior-kickoff-dca2ef83c670?source=rss-631df0a86316------2</link>
            <guid isPermaLink="false">https://medium.com/p/dca2ef83c670</guid>
            <dc:creator><![CDATA[Moustache Data - Mateusz Wąsalski]]></dc:creator>
            <pubDate>Tue, 11 Nov 2025 10:27:03 GMT</pubDate>
            <atom:updated>2025-11-11T10:27:03.847Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[‘How many of these were new to you?’]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-snippet">Let&#x2019;s go with Python as first.</p><p class="medium-feed-link"><a href="https://medium.com/@m.wasalski/how-many-of-these-were-new-to-you-04fefc29a4b9?source=rss-631df0a86316------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@m.wasalski/how-many-of-these-were-new-to-you-04fefc29a4b9?source=rss-631df0a86316------2</link>
            <guid isPermaLink="false">https://medium.com/p/04fefc29a4b9</guid>
            <dc:creator><![CDATA[Moustache Data - Mateusz Wąsalski]]></dc:creator>
            <pubDate>Mon, 04 Aug 2025 22:24:23 GMT</pubDate>
            <atom:updated>2025-08-04T22:24:23.454Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Week 30 —Data Engineering Medium summary]]></title>
            <link>https://medium.com/@m.wasalski/week-30-data-engineering-medium-summary-b08ac0231b42?source=rss-631df0a86316------2</link>
            <guid isPermaLink="false">https://medium.com/p/b08ac0231b42</guid>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[data-engineering]]></category>
            <dc:creator><![CDATA[Moustache Data - Mateusz Wąsalski]]></dc:creator>
            <pubDate>Mon, 28 Jul 2025 22:30:42 GMT</pubDate>
            <atom:updated>2025-07-28T22:30:42.785Z</atom:updated>
            <content:encoded><![CDATA[<p>Hello Awesome Mediumers!</p><p>Since I feel like the Medium Daily Digest doesn’t fully meet my reading needs, I decided to start summarizing what I’ve read (and <em>actually tried</em>, at least partially) over the past week and share it with you. From my perspective, many authors who create amazing content aren’t being highlighted enough in the daily digest — so let’s give them the attention they truly deserve :)</p><p><strong>Disclaimer:</strong> these articles are not from week 30, I just found them in week 30. If you know how to properly filter out articles for given week or day and proper topic please pm me…</p><p><strong>#Python</strong></p><p>#1 — <a href="https://medium.com/@abdur.rahman12">abdur.rahman12</a></p><p>For number 5 I would encourage you to get some kind of ‘Exception’ list with any LLM and if you are using python on a daily basis or even from time to time at your work it could help you a lot.</p><p><a href="https://medium.com/@abdur.rahman12/10-outdated-python-practices-you-need-to-stop-using-right-now-8dd688e01045">https://medium.com/@abdur.rahman12/10-outdated-python-practices-you-need-to-stop-using-right-now-8dd688e01045</a></p><p>#2</p><p><strong>Numbers 1 and 3 are my favorites here.</strong> Just a heads-up: tools like number 2 might be restricted on your work notebook, so use them with caution.</p><p><a href="https://python.plainenglish.io/the-way-top-1-developers-use-ai-will-shock-you-a6116b52f333">https://python.plainenglish.io/the-way-top-1-developers-use-ai-will-shock-you-a6116b52f333</a></p><p>#3-<a href="https://medium.com/@anmol3015">https://medium.com/@anmol3015</a></p><p>Nothing to add here, to be honest — it’s pretty straightforward and easy to read. Just a reminder: in a work environment, you’re writing code for others too. So if the performance is similar, always choose the approach that’s easiest for others to read and understand.</p><p><a href="https://medium.com/codex/its-time-to-replace-loops-in-python-let-s-do-it-now-35804d828f5e">https://medium.com/codex/its-time-to-replace-loops-in-python-let-s-do-it-now-35804d828f5e</a></p><p>#4-<a href="https://medium.com/@frank-andrade">https://medium.com/@frank-andrade</a></p><p>Personally, I use NotebookLM and Claude and I’m more than happy with how they support my daily tasks and learning. Even though NotebookLM is quite simple, I feel like it still requires some ‘practice’.</p><p><a href="https://medium.com/artificial-corner/how-id-learn-python-faster-using-ai-584b385f3fbf">https://medium.com/artificial-corner/how-id-learn-python-faster-using-ai-584b385f3fbf</a></p><p>#5-<a href="https://medium.com/@roelljr">https://medium.com/@roelljr</a></p><p>It might feel a bit overwhelming at first, but it’s a really good cheat sheet. My recommendation: read it from top to bottom, and while you’re going through it, take notes on which of your regular tasks could be automated with these scripts. That way, you’ll gain a better understanding of what’s actually possible with Python — and you’ll definitely make your life easier.</p><p><a href="https://medium.com/stackademic/ultimate-python-cheat-sheet-practical-python-for-everyday-tasks-c267c1394ee8">https://medium.com/stackademic/ultimate-python-cheat-sheet-practical-python-for-everyday-tasks-c267c1394ee8</a></p><p><strong>#SQL</strong></p><p>#1 — <a href="https://medium.com/@CodeWithHannan">CodeWithHannan</a></p><p>At least half of these queries have come up in my interviews at some point. Regardless of your seniority, it’s worth revisiting them from time to time — you’d be surprised how tricky SQL can be.</p><p><a href="https://medium.com/@CodeWithHannan/you-dont-know-sql-until-you-ve-written-these-10-queries-35a011802a22">https://medium.com/@CodeWithHannan/you-dont-know-sql-until-you-ve-written-these-10-queries-35a011802a22</a></p><p>#2-<a href="https://medium.com/@analystuttam">https://medium.com/@analystuttam</a></p><p>Sometimes comments are as good as article.</p><p><a href="https://medium.com/data-science-collective/sql-performance-trick-boost-query-speed-80-percent-54751bcb848c">https://medium.com/data-science-collective/sql-performance-trick-boost-query-speed-80-percent-54751bcb848c</a></p><p><strong>#Data Engineering</strong></p><p>#1-<a href="https://medium.com/@shenoy.shashwath">https://medium.com/@shenoy.shashwath</a></p><p>(…)in 2012, GitHub was still a rising platform. Today, it’s a treasure trove.(…)</p><p><a href="https://medium.com/@shenoy.shashwath/the-best-github-repos-for-data-engineers-updated-2025-d00fb4ad81d3">https://medium.com/@shenoy.shashwath/the-best-github-repos-for-data-engineers-updated-2025-d00fb4ad81d3</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b08ac0231b42" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to edit cells in Excel with Python and save it as PDF]]></title>
            <link>https://medium.com/@m.wasalski/how-to-edit-cells-in-excel-with-python-and-save-it-as-pdf-b749fcff676d?source=rss-631df0a86316------2</link>
            <guid isPermaLink="false">https://medium.com/p/b749fcff676d</guid>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[python]]></category>
            <dc:creator><![CDATA[Moustache Data - Mateusz Wąsalski]]></dc:creator>
            <pubDate>Thu, 04 Jan 2024 20:10:53 GMT</pubDate>
            <atom:updated>2024-01-04T20:10:53.369Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Hello Mediumers!</strong></p><p>This is my first post here and the only one where I’ll write a few words not strictly related to the main theme. The rest of the posts will be straight to the point ;)</p><p>Just call me Mathew. I work as an Analytics Engineer, and the main task of our team is RPA, which stands for Robotics Process Automation. Essentially, every boring and repetitive task is to be automated so that Business* has time for other tasks that are more creative and aimed at pushing the company forward.</p><p>Besides adding real-life examples (there won’t be any analysis with Iris dataset here ;) ) I’ll also mainly be publishing EDA datasets, which I found interesting to analyze. At the bottom, there will always be links to my Kaggle.com, articles and/or YouTube videos that have helped me.</p><p>If, looking at my work here, you see areas for improvement please don’t DM me, put solution in the comments what you would improve so others can take a look. In the script I always count the time passed for each section so if your solution is simpler, more readable or faster, the article will be updated and next to the solution there will be ‘thanks’ and link to your profile (medium.com, linkedin.com — your choice).</p><p>*Business — end users from business side.</p><p><strong>So, let’s go!</strong></p><p>Business case:</p><p><em>‘We need to update Excel which contains daily sales data. After update it must be saved to </em><strong><em>.pdf</em></strong><em> with date of last sales in title. PDF will be sent via email right after updating’</em></p><p>Let’s import what we need:</p><pre># # Stopwatch start<br>import time<br>start_time = time.time() </pre><pre>import sqlalchemy<br>from sqlalchemy import create_engine<br>import openpyxl<br>import pandas as pd</pre><p>Because data is stored in database we need to get it somehow:</p><pre>SERVER=&#39;server.net&#39;<br>DB=&#39;database.db&#39;<br>DR=&#39;ODBC Driver 17 for SQL Server&#39;<br>UID=&#39;login.user&#39;<br>PW=&#39;password.pw&#39;<br><br>DB_Connection = f&#39;mssql://{UID}:{PW}@{SERVER}/{DB}?driver={DR}&#39;<br><br>engine=create_engine(DB_Connection)<br>connection=engine.connect()</pre><p>Next step is querying, where we only need last day:</p><pre>daily_sales=pd.read_sql_query\<br>(&quot;SELECT top 1 * FROM sales_europe order by Date desc&quot;,connection)</pre><p>Extract the value and store it in a variable. ‘<strong>Date</strong>’, ‘<strong>West Region</strong>’ etc. are names of the columns. We have floats in db but client wanted no decimals.</p><p>Variable names are not perfect but in this case it was way easier to put values in appropriate cells. This example is small while real life file was bigger and more complex so naming variables this way helped a lot in developing draft version.</p><p>After getting green light from Businees that it works fine you should change the naming so your colleagues will not spend too much time figuring out what for example C8 means.</p><pre>C6 = daily_sales[&#39;Date&#39;]<br>C8 = daily_sales[&#39;West Region&#39;].astype(&#39;int&#39;)<br>C9 = daily_sales[&#39;East Region&#39;].astype(&#39;int&#39;)<br>C10 = daily_sales[&#39;North Region&#39;].astype(&#39;int&#39;)<br>C11 = daily_sales[&#39;South Region&#39;].astype(&#39;int&#39;)<br>C13 = C8+C9+C10+C11</pre><p>Here we have last steps.</p><p>What is interesting, we don’t need to make any walkaround to save it to <strong>.pdf</strong>. Just replace variable <em>excel_file_path </em>with path where file will be saved and replace .xlsx with .pdf.</p><pre># Path to your Excel file<br>excel_file_path = &#39;Destkop/Daily_sales_report.xlsx&#39;<br><br>#Today&#39;s date<br>C4 = pd.to_datetime(&#39;today&#39;).strftime(&#39;%d-%m-%Y&#39;)<br><br># Load the workbook and select the first sheet<br>wb = openpyxl.load_workbook(excel_file_path)<br># I left it like this because it&#39;s a Excel with one sheet<br>sheet = wb.active  # or wb[&#39;SheetName&#39;] if you need to activate other sheet<br><br>sheet[&#39;C4&#39;] = C4<br><br>sheet[&#39;C6&#39;] = C6<br><br>sheet[&#39;C8&#39;] = C8<br>sheet[&#39;C9&#39;] = C9<br>sheet[&#39;C10&#39;] = C10<br>sheet[&#39;C11&#39;] = C11<br>sheet[&#39;C13&#39;] = C13<br><br># Save the workbook<br>wb.save(excel_file_path)<br><br># or<br><br># What will save your .xlsx file into .pdf<br>wb.save(f&#39;Desktop/Daily_sales_report_{C6}.pdf&#39;)</pre><pre># Stopwatch stop<br>end_time = time.time()<br>total_time_taken = end_time - start_time<br>print(f&quot;Total time taken: {total_time_taken} seconds&quot;)</pre><p>and Proof Of Concept (POC) looks like this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/855/1*WmGIowdzjaJyhhCFeMJfOw.png" /></figure><p>In next article I will dive deeper into <strong>openpyxl </strong>library and how to make this report more pleasing to the eye.</p><p>P.S.</p><p>I know that we can connect Excel to SQL with Power Query but:</p><ul><li>we don’t give credentials and db logic to people outside development team</li><li>path to Desktop is just an example, we store files on Sharepoint where we cannot refresh the <strong>.xlsx</strong> file like we would normally do while working on it on desktop</li><li>I tried to do it differently but this was the only way to manipulate data inside Excel file without ‘physically opening it’ (script is running automatically, so I had to be sure it will not crash)</li><li>of course there are other solutions involved like <strong>Azure Logic Apps</strong>, so the <strong>.pdf</strong> file is emailed using one of the workflows made in <strong>Logic Apps</strong></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b749fcff676d" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>