<?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 Khalid El Mouloudi on Medium]]></title>
        <description><![CDATA[Stories by Khalid El Mouloudi on Medium]]></description>
        <link>https://medium.com/@khalidelmouloudi?source=rss-4ea0835ec31e------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/2*fk9hQEYn9OnSTgKgNFpsXQ.jpeg</url>
            <title>Stories by Khalid El Mouloudi on Medium</title>
            <link>https://medium.com/@khalidelmouloudi?source=rss-4ea0835ec31e------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 15:27:49 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@khalidelmouloudi/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[30 Pandas Exercises With Real Hospital Data (+Hints & Solutions)]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://python.plainenglish.io/30-pandas-exercises-with-real-hospital-data-hints-solutions-0fe5d95be71a?source=rss-4ea0835ec31e------2"><img src="https://cdn-images-1.medium.com/max/1600/1*Y7QMuAWvzSXXfHWAu73Mgg.png" width="1600"></a></p><p class="medium-feed-snippet">Train your Pandas knowledge with these 30 real-world exercises!</p><p class="medium-feed-link"><a href="https://python.plainenglish.io/30-pandas-exercises-with-real-hospital-data-hints-solutions-0fe5d95be71a?source=rss-4ea0835ec31e------2">Continue reading on Python in Plain English »</a></p></div>]]></description>
            <link>https://python.plainenglish.io/30-pandas-exercises-with-real-hospital-data-hints-solutions-0fe5d95be71a?source=rss-4ea0835ec31e------2</link>
            <guid isPermaLink="false">https://medium.com/p/0fe5d95be71a</guid>
            <category><![CDATA[python]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-science-training]]></category>
            <category><![CDATA[pandas]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Khalid El Mouloudi]]></dc:creator>
            <pubDate>Fri, 23 Aug 2024 17:29:30 GMT</pubDate>
            <atom:updated>2024-08-30T00:42:10.053Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Getting insights about businesses and locations from Google Maps]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/getting-insights-about-businesses-and-locations-from-google-maps-3f8a5739059a?source=rss-4ea0835ec31e------2"><img src="https://cdn-images-1.medium.com/max/1600/1*13rUxP6QOn6BS9DM5aizmw.png" width="1600"></a></p><p class="medium-feed-snippet">Let&#x2019;s see how to leverage the power of Python and Selenium to tap into the data Google Maps has about businesses and locations of interest</p><p class="medium-feed-link"><a href="https://medium.com/data-science/getting-insights-about-businesses-and-locations-from-google-maps-3f8a5739059a?source=rss-4ea0835ec31e------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/getting-insights-about-businesses-and-locations-from-google-maps-3f8a5739059a?source=rss-4ea0835ec31e------2</link>
            <guid isPermaLink="false">https://medium.com/p/3f8a5739059a</guid>
            <category><![CDATA[python]]></category>
            <category><![CDATA[web-scraping]]></category>
            <category><![CDATA[selenium]]></category>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[pandas]]></category>
            <dc:creator><![CDATA[Khalid El Mouloudi]]></dc:creator>
            <pubDate>Mon, 02 Mar 2020 03:59:36 GMT</pubDate>
            <atom:updated>2020-03-02T10:17:21.090Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Using Python and Selenium to get coordinates from street addresses]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/using-python-and-selenium-to-get-coordinates-from-street-addresses-62706b6ac250?source=rss-4ea0835ec31e------2"><img src="https://cdn-images-1.medium.com/max/1700/1*oNUuJJUC_J7hCzbZ0zds2Q.jpeg" width="1700"></a></p><p class="medium-feed-snippet">You&#x2019;ll be able to generate coordinates out of street addresses by web scraping Google Maps using Selenium (Jupyter Notebook inside)</p><p class="medium-feed-link"><a href="https://medium.com/data-science/using-python-and-selenium-to-get-coordinates-from-street-addresses-62706b6ac250?source=rss-4ea0835ec31e------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/using-python-and-selenium-to-get-coordinates-from-street-addresses-62706b6ac250?source=rss-4ea0835ec31e------2</link>
            <guid isPermaLink="false">https://medium.com/p/62706b6ac250</guid>
            <category><![CDATA[python]]></category>
            <category><![CDATA[web-scraping]]></category>
            <category><![CDATA[pandas]]></category>
            <category><![CDATA[selenium]]></category>
            <category><![CDATA[mapping]]></category>
            <dc:creator><![CDATA[Khalid El Mouloudi]]></dc:creator>
            <pubDate>Mon, 27 Jan 2020 22:45:41 GMT</pubDate>
            <atom:updated>2020-01-29T13:35:31.704Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[5 CSS snippets for better looking Pandas Dataframes]]></title>
            <link>https://medium.com/analytics-vidhya/5-css-snippets-for-better-looking-pandas-dataframes-ad808e407894?source=rss-4ea0835ec31e------2</link>
            <guid isPermaLink="false">https://medium.com/p/ad808e407894</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[pandas]]></category>
            <category><![CDATA[css]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[jupyter-notebook]]></category>
            <dc:creator><![CDATA[Khalid El Mouloudi]]></dc:creator>
            <pubDate>Fri, 20 Dec 2019 23:38:36 GMT</pubDate>
            <atom:updated>2020-01-05T12:48:53.909Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*foPRcDtqPfC4isQXGdUokw.jpeg" /></figure><p>If you work often with Pandas in Jupyter Notebooks, you’ll realise that the default look and style of the Dataframes doesn’t offer much <strong>contrast between the indexes and the data itself :</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*X0CBdljT2k12N-jydcI_5w.png" /></figure><p>This gets worse when you have to <strong>group by</strong> two or more variables or use <strong>hierarchical indexing</strong> :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/535/1*Wv1dRmTmoFpYR0hdeM36CA.png" /></figure><p>Luckily, you can use CSS right inside the notebook to make Dataframes look a bit better, even if you don’t know any CSS at all. All you have to do is copy/paste the code snippets that I will share with you and then run them in a notebook cell.</p><h3>How it works :</h3><p>There are many ways to customize the look of a notebook. For me, the easiest way is to make use of the <strong>magic function</strong> <strong>%%HTML</strong>followed by the <strong>&lt;style&gt;</strong> and <strong>&lt;/style&gt;</strong> tags like this :</p><pre>%%HTML<br>&lt;style&gt;.dataframe th{<br>background:#3f577c; <br>font-family:monospace; <br>color:white; <br>border:3px solid white; <br>text-align:left !important;}<br>&lt;/style&gt;</pre><p>Once you run this cell, your Dataframe will look like this :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/992/1*yUnBVmoUYNr2ROOiWj8wEQ.png" /></figure><p>and like this with hierarchical indexing :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/574/1*CJmqLB8nPXXtHVX2KMIb6w.png" /></figure><p>If you want to <strong>go back to the default style</strong>, just comment out the whole CSS cell (select all and then do CTRL+/) and run the cell again.</p><p>This is the style I often go with because :</p><ul><li>the color is easy on the eyes</li><li>it helps to tell indexes and the data itself apart</li><li>the font used for the indexes (monospace) makes it easy to spot capital letters and differentiate between characters that could get confused for each other (0 and O for example).</li></ul><p>Next, I’ll give you 5 different CSS snippets you can choose from to style your Dataframes however you like. You can also mix and match different aspects of these styles as you like; all you have to do is change the values of the properties you want to alter.</p><p><strong>NB 1: </strong><em>we’ll only be touching up the indexes in this article. I don’t think it will do us any good to change how the data itself looks.</em></p><p><strong>NB 2</strong>: <em>if you think the CSS code cell is taking a lot of space in your notebook, you can remove all spaces from the code and the style should work still (there’s always a line break after the magic function </em>%%HTML<em>). The minified CSS code will look like this :</em></p><pre>%%HTML<br>&lt;style&gt;.dataframe th{background:#3f577c;font-family:monospace;color:white;border:3px solid white;text-align:left!important;}&lt;/style&gt;</pre><h3>1. Dashing Orange :</h3><p>How it looks :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/926/1*mRSliqrwxextifFWF-m2CA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/556/1*ELjFqMB6y5RGQkBRKASOlw.png" /></figure><p>The CSS code:</p><pre>%%HTML<br>&lt;style&gt;.dataframe th{<br>background: rgb(255,122,56);<br>background: linear-gradient(0deg, rgba(255,122,56,1) 0%, rgba(255,83,83,1) 100%);<br>padding: 10px;<br>font-family: trebuchet ms;<br>font-size: 110%;<br>color: white;<br>border:1px dashed white;<br>text-align:left !important;<br>-moz-border-radius: 3x;<br>-webkit-border-radius: 3px;<br>}.dataframe thead{border:none; !important;}&lt;/style&gt;</pre><p>This style uses an <strong>orange gradient</strong> with a <strong>dashed white border</strong> between cells. The font is <strong>Trebuchet MS</strong> with a <strong>110%</strong> font size. Borders are <strong>slightly rounded </strong>in this one.</p><h3>2. Dotted Green :</h3><p>How it looks :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/972/1*9z1-h5ExjCwtF3o2wbwanQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/619/1*1QMmUK074NJnWQO5dMu0sw.png" /></figure><p>The CSS code:</p><pre>%%HTML<br>&lt;style&gt;.dataframe th{<br>background: rgb(0,94,73);<br>background: linear-gradient(71deg, rgba(0,94,73,1) 0%, rgba(18,126,80,1) 100%);<br>padding: 10px;<br>font-family: lucida console;<br>color: #343434;<br>border:2px dotted;<br>text-align:left !important;<br>}&lt;/style&gt;</pre><p>This style uses a dark <strong>green gradient</strong> with a <strong>dotted border</strong>. The font used here is <strong>Ludica Console</strong>.</p><h3>3. Compact Silver :</h3><p>How it looks :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/887/1*EW7HlQbWpJo-ampB5QrCFA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/531/1*muqIwzAol9_R6T2sUbteew.png" /></figure><p>The CSS code :</p><pre>%%HTML<br>&lt;style&gt;.dataframe th{<br>background: rgb(255,255,255);<br>background: radial-gradient(circle, rgba(255,255,255,1) 0%, rgba(236,236,236,1) 100%);<br>padding: 5px;<br>color: #343434;<br>font-family: monospace;<br>font-size: 110%;<br>border:2px solid #e0e0e0;<br>text-align:left !important;<br>}.dataframe{border: 3px solid #ffebeb !important;}&lt;/style&gt;</pre><p>I like this one because of its simplicity. It uses a slight <strong>off-white gradient</strong> with <strong>grey solid borders</strong>. The whole Dataframe has a <strong>faint pink border</strong>. The font used here is <strong>Monospace</strong>.</p><h3>4. Teal gradient :</h3><p>How it looks :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/966/1*JclI8g2-SigTmkJV2_UBYQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/614/1*GbDZARs6upzD5odmOLR8ZA.png" /></figure><p>The CSS code :</p><pre>%%HTML<br>&lt;style&gt;.dataframe th{<br>background: rgb(61,164,166);<br>background: linear-gradient(0deg, rgba(61,164,166,1) 0%, rgba(31,198,190,1) 100%);<br>padding: 10px;<br>font-family: arial;<br>font-size: 120%;<br>color: white;<br>border:2px solid white;<br>text-align:left !important;}<br>&lt;/style&gt;</pre><p>This style uses a light <strong>teal gradient</strong>, <strong>Arial </strong>as the font of choice and <strong>120%</strong> for font-size.</p><h3>5. Golden haze :</h3><p>How it looks :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/968/1*Tt0JXJXx5HYcvy_uSnpV4Q.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/616/1*N0zXmT-SyrnXWD8Wdn4zEg.png" /></figure><p>The CSS code:</p><pre>%%HTML<br>&lt;style&gt;.dataframe th{<br>background: rgb(237,225,32);<br>background: radial-gradient(circle, rgba(237,225,32,1) 0%, rgba(233,202,60,1) 100%);<br>padding: 10px;<br>font-family: arial black;<br>font-size: 105%;<br>color: #313131;<br>border:2px solid white;<br>text-align:left !important;<br>}&lt;/style&gt;</pre><p>This style uses a <strong>golden radial gradient</strong>, <strong>Arial Black </strong>as the font of choice and <strong>105%</strong> for font-size.</p><p>If you want to generate your own colors and gradients, you can go to <a href="https://cssgradient.io/">cssgradient.io</a> to generate the CSS code you need for the background property.</p><p>Which one of these did you like?</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ad808e407894" width="1" height="1" alt=""><hr><p><a href="https://medium.com/analytics-vidhya/5-css-snippets-for-better-looking-pandas-dataframes-ad808e407894">5 CSS snippets for better looking Pandas Dataframes</a> was originally published in <a href="https://medium.com/analytics-vidhya">Analytics Vidhya</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Let your presentation do the talking (literally)]]></title>
            <link>https://medium.com/@khalidelmouloudi/let-your-presentation-do-the-talking-literally-afdc5aae04ce?source=rss-4ea0835ec31e------2</link>
            <guid isPermaLink="false">https://medium.com/p/afdc5aae04ce</guid>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[design]]></category>
            <category><![CDATA[powerpoint]]></category>
            <category><![CDATA[teaching]]></category>
            <category><![CDATA[presentations]]></category>
            <dc:creator><![CDATA[Khalid El Mouloudi]]></dc:creator>
            <pubDate>Sat, 28 Sep 2019 23:20:33 GMT</pubDate>
            <atom:updated>2019-09-28T23:20:33.382Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Gmw48ALkhmCaOWFYOSwYlw.jpeg" /><figcaption>rawpixel.com</figcaption></figure><p>Have you ever used <strong>sound on a PowerPoint presentation</strong>? If you never tried it (or did with unsatisfying results), I want to share with you a simple but powerful way to leverage the versatility and intimacy of sound to get your message across.</p><p>Here’s a video showing a “talking” demo presentation I specifically made for this article :</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fao0p4udb-mY%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dao0p4udb-mY&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fao0p4udb-mY%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/a538935bc5bc8e57745c3255740f5261/href">https://medium.com/media/a538935bc5bc8e57745c3255740f5261/href</a></iframe><p>As shown in the preview above, the PowerPoint presentation includes two main sound components :</p><ul><li>gentle <strong>background music</strong> playing and looping without interruptions ;</li><li>engaging <strong>voice-over</strong> that not only reads what’s written in each slide, but expands on it (I used an artificially generated voice with some noticeable hiccups because this is just a demo, but you can record your own voice and then enhance it for better results).</li></ul><p>The music and voice-over are not just for show; they have a <strong>functional and didactical purpose</strong> by helping your audience feel comfortable, engaged and ready to follow your story.</p><p>You can download the full presentation and all the elements I used to create it (audio and graphics) in <a href="https://www.dropbox.com/sh/lq88nfcqy3tk01j/AADXFMW7t-A5sldIfC5iGqLZa?dl=0">my dropbox folder here</a>.</p><h3>But, why?</h3><p>Wouldn’t sound just make a presentation more complicated than it needs to be? Well, I wouldn’t use this format for every presentation and in all occasions. There are, however, many cases where this could be a game changer :</p><ul><li>If your audience is more comfortable listening than reading, then voice-over will definitely help you make your message more understandable and approachable to them. I would recommend using a “talking” presentation if you are addressing kids or teens in an educational setting, or if the audience is illiterate (it’s still a problem in many developing countries around the globe) or suffering from short-sightedness (the elderly for example) ;</li><li>If you find yourself doing the same presentation more often than is comfortable (salespeople know what I’m talking about), then a “talking” presentation would “share the load” with you, so you’ll save your breath for side explanations or answering questions.</li></ul><p>Okay, but why not just go with a video at this point? Well, unlike videos, you don’t have to use the pause button whenever you want to expand on some ideas during the presentation. The voice-over stops at the end of each slide to give you time to interject, and only continues when you move on to the next slide. In addition to that, video editing takes more time and effort than audio editing, which is easier and more accessible as we’re going to see in the next chapters.</p><h3>First, the PowerPoint presentation :</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6G2fvs0WarXJHDQWtecmCQ.jpeg" /></figure><p>All good things start very simple. For the purposes of this article, you can download the one I made and practice on it. All the files (audio and graphics), are downloadable from <a href="https://www.dropbox.com/sh/lq88nfcqy3tk01j/AADXFMW7t-A5sldIfC5iGqLZa?dl=0">my dropbox folder here</a>.</p><p>But first, let’s agree on some guidelines for a good basic presentation to start things on the right foot :</p><ul><li>It shouldn’t hold more than one or two ideas per slide ;</li><li>Don’t be afraid to drag an idea or a process across multiple slides if it’s long or complicated. Nothing screams inefficiency louder than a crammed up slide, so always make sure to break it down into small digestible chunks ;</li><li>A combination of text and visual elements is a must. No one wants to stare at a wall of text no matter how important it is ;</li><li>Always include a slide counter. Ten minutes in, your audience is already wondering how much more information is still ahead. To give you an example, I included a simple progress bar at the bottom of each slide showing exactly where we are at any given moment ;</li><li>I recommend you use two fonts at the most: a Serif font for the titles and a Sans Serif font for the text. The same goes for colors. This is subject to personal preferences though, so don’t be afraid to experiment and ask the opinion of people around you ;</li><li>For each slide, write down the script you’re going to record in the notes section of PowerPoint (it’s only visible to you while you’re working on the presentation). It doesn’t have to be exactly the same as the written text on each slide.</li></ul><h3>Second, let’s record some audio :</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4TSPab00OBBnWXD1PiBREg.jpeg" /><figcaption><a href="https://unsplash.com/@namroud">Namroud Gorguis</a> — unsplash.com</figcaption></figure><p>If you have the time and means to hire a trained and well equipped professional to produce high quality voice-overs, then by all means do so (especially if the stakes are high).</p><p>However, in case you’re falling short on time and resources, or if you’re doing the presentation just for fun or for a charity event, then you can do a very good job recording, cleaning and enhancing the audio voice-overs yourself using simple and free tools.</p><p>In case you hate how your recorded voice sounds (everyone else does, except for Morgan Freeman probably), don’t worry; you can completely enhance it by changing the Pitch and the Tempo using the free and open-source audio processing tool <a href="https://www.audacityteam.org/">Audacity</a> we’ll see later.</p><p>Let’s dive right in, step by step :</p><ul><li><strong>Setting up Audacity</strong>: you can download <a href="https://www.audacityteam.org/">Audacity for free</a>. It’s available for Windows, Mac and Linux. After the setup, launch the program.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*A-F8c8eHYBhFi-o0Ot6BVg.jpeg" /><figcaption>Audacity is free but very powerful.</figcaption></figure><ul><li><strong>Recording</strong>: if you plan on doing this yourself, you can use any voice recording app on your phone. Just make sure you’re in a quiet environment. You can also use your headset microphone to record sounds with Audacity. There are plenty of videos on Youtube showing how you can achieve that.</li></ul><p>While recording, allow a 2 seconds pause before talking. This is useful to eliminate background noises later on, and also to space out the voice-overs that run back-to-back during the presentation. Don’t worry, we can clip out any extra silence inside PowerPoint. Also, make sure to give your tracks meaningful names, for example ‘<em>1. slide 1 title</em>’, ‘<em>2. slide 2 text</em>’ and so on. This will help you know exactly where to put each file inside the presentation.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/949/1*Wloj16sk8lqxd2qs3KqcpA.jpeg" /><figcaption>Make sure to give your audio files clear names. You’ll need to know which file to import into which slide and in which order.</figcaption></figure><ul><li><strong>Importing the audio</strong>: Audacity can handle a variety of audio formats. To import an audio file, just drag and drop it into the interface.</li><li><strong>Eliminating background noise</strong>: using the ‘I’ cursor, click and drag on top of the track to select the first seconds of silence (silence if marked as a fairly flat line in the blue audio spectrum). Then, click Effect &gt; Noise Reduction… and hit Get noise profile. This will close the window. Now, select everything by clicking on Select&gt; All (or by using CTRL+A on Windows or Command+A on Mac) and reopen the ‘Noise Reduction’ window again. This time, click on preview. You’ll notice that the noise got a lot quieter. If not, play with the ‘Noise Reduction (dB)’ slider until you get the desired effect (don’t go overboard with it though, because that may dampen the other spoken parts that we want to keep). Once satisfied, hit ‘Ok’.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/471/1*hijIKDWY3USeAgTJs8m_3A.jpeg" /></figure><ul><li><strong>Changing the Pitch</strong>: now this one will completely change how your voice sounds by making it deeper (by lowering the pitch) or higher (by upping the pitch). To do so, select everything by clicking on Select&gt; All (or by using CTRL+A on Windows or Command+A on Mac). Then click on Effect &gt; Change Pitch…. In this window, you can play with the ‘Percent Change’ value, modifying it by small increments (-3, -5, -10 / 3, 5, 10, …) and clicking on ‘Preview’ to see if the desired degree of deepness or highness is achieved.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/471/1*UHIhauPDLNTV_XfSCOQezQ.jpeg" /></figure><ul><li><strong>Changing the Tempo</strong>: <em>tempo </em>is not the same as <em>speed</em>. If you tune the tempo up (or down), the words get spaced out (or squeezed), but the pitch (how deep or high your voice sounds) stays the same. However, when you change speed, the audio speeds up or slows down and the pitch changes too, which we don’t want in this case. So, select everything again and click on Effect &gt; Change Tempo…. Like before, you can play with the ‘Change Percent’ value until you’re satisfied by how upbeat or laid back your speaking sound is (hit ‘Preview’ to hear the difference).</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/471/1*0svkAvhcSMaJdYvUeJqM0g.jpeg" /></figure><ul><li><strong>Exporting the audio</strong>: If you’re satisfied with the result, hit File &gt; Export &gt; Export as MP3.</li></ul><p>Now, wouldn’t it be tedious if you have to do all these steps with each recorded sound file? Yes it would! That’s why I’m going to show you how to <strong>apply all these enhancements above to all recorded files at once</strong>. For this, we need to set up a ‘Chain’ :</p><ul><li><strong>Setting up a Chain</strong>: a <em>chain </em>is just a sequence of operations you want Audacity to conduct on a file or a selection of files. To set one up, click on File &gt; Chains &gt; Edit Chains. Left of the window, click ‘Add’ and give your Chain a meaningful name, then hit ‘Ok’. You’ll see that your new chain got selected with an empty first operation ’01 — End’. Let’s add our first operation: double click on ‘End’ (the first operation) and choose ‘Noise Reduction’ and then ‘Edit parameters’. The same widow as before will appear and it will remember all the settings you have chosen the last time. Hit ‘Ok’. Do the same with all the next steps (pitch and tempo). At the end, add a final operation called ‘Export as MP3’. Hit ‘Ok’ to save.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/821/1*6k6uKR3LoO2S1j_pTtaR1w.jpeg" /></figure><ul><li><strong>Applying a Chain</strong>: to apply the chain, click on File &gt; Chains &gt; Apply Chain…. Choose your chain and click ‘Apply to files …’. Select all the audio files you recorded and hit ‘Ok’. You’ll find a new folder containing all the processed audio tracks where your original files are.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/397/1*dXIKLJut7Fy7tlPk1PC0jw.jpeg" /></figure><p>Alternatively, you can do as I did and get an <strong>artificially generated voice-over</strong>. There are many solutions out there, but the best ones cost money. I used a free but surprisingly good one here: <a href="https://www.askeygeek.com/ai-text-to-speech/">https://www.askeygeek.com/ai-text-to-speech</a>, and then I used all the enhancement steps we just covered for added quality (the voice I went with was ‘Brian-British English’. Kendra is also good for a female voice). It sure has some minor imperfections here and there, but it’s just for the purpose of making this demo.</p><h3>Now, let’s combine presentation and sound together !</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*c0_SyZBQRFbLTu--gEj7Tw.jpeg" /></figure><ul><li>Let’s take Slide 1 as an example. To add our processed audio voice-over to it, all you have to do is go to Insert&gt;Audio &gt;Audio On My PC …, Then select your audio file ‘<strong>1. Slide 1 title</strong>’.</li></ul><p>For PowerPoint 2013 and above, the supported audio formats are <strong>.mp3</strong>, <strong>.wma</strong>, <strong>.wav</strong>, <strong>.m4a</strong>,<strong> .mp4</strong>, <strong>.aiff</strong>, <strong>.au</strong> and <strong>.mid</strong> or <strong>.midi</strong>. For more information about other versions, visit <a href="https://support.office.com/en-us/article/video-and-audio-file-formats-supported-in-powerpoint-d8b12450-26db-4c7b-a5c1-593d3418fb59">Microsoft’s page on the subject</a>.</p><ul><li>After adding the audio, you’ll get a grey speaker icon. Hover above it and slide the volume all the way up. You can also resize it and place it somewhere out of the way (it won’t matter where because it will be hidden in Slide Show mode).</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/582/1*x5quwy5cKAaeSXaa-wdHiQ.jpeg" /></figure><ul><li>Click on the grey speaker icon and go to Playback above in the ribbon. Check ‘Hide during show’ so the icon would be hidden once the Slide Show mode starts.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/582/1*-u8UppFPJcTZki83cMD1zg.jpeg" /></figure><p>Do the above steps to all audio tracks. This can get a little bit tedious because there is no possible way to automate these steps. Next, we’ll see how to tell PowerPoint when to start and stop the audio in relation to the other graphical and text elements that are already animated.</p><h3>The Animation Pane is your playground :</h3><p>For this next bit, you need to really understand what’s going on in the Animation Pane. It’s the little window that controls all animations and the order in which they fire or stop, including audio.</p><p>Let’s take slide 6 as an example because it has 3 audio tracks inside it. Go to Animationand click on Animation Pane. Now this is where it gets a little bit tricky :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/408/1*xLOBxwb4QTuNBrqdKtl3ZQ.jpeg" /></figure><p>As you can see, I have already included some animations for the title <strong>‘TextBox 4’</strong>, the block of text<strong> ‘TextBox 3’</strong>, and the pictures <strong>‘Picture 13’, 12 &amp;1</strong>. When I added the 3 audio tracks, the Animation Pane automatically added them as small blue triangles as shown above.</p><p>The order here is very important: we want our first audio track <strong>‘9. slide 6 title’</strong> to play right after the title animation finishes, and the next one <strong>‘10. slide 6 explanation 1’</strong> to start in synchro with <strong>‘TextBox 3’</strong> (the mouse icon means you have to click or hit a key on the keyboard for the next actions to take place).</p><p>Once the track <strong>‘10. slide 6 explanation 1’</strong> finishes playing, the next and third track <strong>‘11. slide 6 explanation 2’</strong> will play (hence the little clock icon). To choose whether an audio track plays with or after a previous action, just right click on it and choose the option you want :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/408/1*VIMmsrv_E7Q88fVCgfQJtw.jpeg" /></figure><p>To change the order of an element, just click and drag it where you want it to be.</p><p>Once you got the order right (this will take some back and forth between the Slide show mode and the Animation Pane), it’s time to trim any extra silence. To do that, click on the gray speaker icon, and then go to Playback&gt;Trim Audio.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/943/1*bg04RCYnbLmSufee61yW7g.jpeg" /></figure><p>Now, use the green and red sliders to outline the part you want to keep. Anything outside these markers is going to be clipped out. Allow some silence before the track for pauses in the speaking (1.5 seconds sounds natural) :</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/445/1*_JJcls7gCminNh-cOEAlTQ.jpeg" /></figure><h3>And now for some background music :</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/763/1*lXTHrnbiTcepkNib6574JA.jpeg" /></figure><p>The background music must be added to the cover slide. You do all the previous steps we covered before, except this time, inside the ‘Playback’ options, you click on ‘Play in Background’. Make sure the cases ‘Play Across Slides’ and ‘Loop until Stopped’ are also ticked.</p><p>Now once you fire your presentation in Slide Show mode from the cover slide, the background music will start and loop until you finish your presentation. However, if you start your Slide Show from a slide other than the cover slide, the music will not start.</p><p>One last thing: hover above your background music icon and slide the volume down to approximately 20% so it won’t be louder than the spoken words.</p><p>Credit goes to jpmarques from <a href="https://www.looperman.com/loops/detail/183303/chill-vibes-mellow-piano-melody-loop-87bpm-hip-hop-rhodes-piano-loop">looperman.com</a> for the music loop I used in this demo. Many thanks!</p><h3>Will the PPTx file contain all the audio files?</h3><p>Yes! If you want to do the presentation on another computer, all you have to copy on your flash drive is the presentation itself. No need to also copy the original audio files.</p><p>The file size is also not a problem because in the case of this demo presentation, the PPTx file without audio has a size of 2.5 Mb, and the one with the audio included weights only 4 Mb.</p><h3>The possibilities are endless !</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*DNlXlkWhQMnIX1gEiCoAow.jpeg" /><figcaption>pixabay.com</figcaption></figure><p>I believe the reason why this format is not taken advantage of very often is because people either go with a basic presentation, or a video in case footage, music and spoken word are needed.</p><p>However, I can think of a lot of uses for this format, being the middle ground between the two, especially in educational and academic settings (teaching languages being an example that comes to mind).</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=afdc5aae04ce" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Matching Messy Pandas columns with FuzzyWuzzy]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/analytics-vidhya/matching-messy-pandas-columns-with-fuzzywuzzy-4adda6c7994f?source=rss-4ea0835ec31e------2"><img src="https://cdn-images-1.medium.com/max/2600/1*u8X2MB-PbC7ukprsBegSjg.jpeg" width="3329"></a></p><p class="medium-feed-snippet">How to use the Python package FuzzyWuzzy to match two Pandas dataframe columns based on string similarity</p><p class="medium-feed-link"><a href="https://medium.com/analytics-vidhya/matching-messy-pandas-columns-with-fuzzywuzzy-4adda6c7994f?source=rss-4ea0835ec31e------2">Continue reading on Analytics Vidhya »</a></p></div>]]></description>
            <link>https://medium.com/analytics-vidhya/matching-messy-pandas-columns-with-fuzzywuzzy-4adda6c7994f?source=rss-4ea0835ec31e------2</link>
            <guid isPermaLink="false">https://medium.com/p/4adda6c7994f</guid>
            <category><![CDATA[pandas]]></category>
            <category><![CDATA[jupyter-notebook]]></category>
            <category><![CDATA[pandas-dataframe]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[fuzzy-matching]]></category>
            <dc:creator><![CDATA[Khalid El Mouloudi]]></dc:creator>
            <pubDate>Mon, 23 Sep 2019 22:33:27 GMT</pubDate>
            <atom:updated>2024-02-01T11:51:17.026Z</atom:updated>
        </item>
    </channel>
</rss>