<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Amit</title>
    <description>The latest articles on DEV Community by Amit (@godlikeme).</description>
    <link>https://dev.to/godlikeme</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4247802%2Fd3b819fe-716f-4616-ba3b-3ce43937a7c4.png</url>
      <title>DEV Community: Amit</title>
      <link>https://dev.to/godlikeme</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/godlikeme"/>
    <language>en</language>
    <item>
      <title>I'm tired of Ai videos</title>
      <dc:creator>Amit</dc:creator>
      <pubDate>Tue, 17 Nov 2026 04:30:43 +0000</pubDate>
      <link>https://dev.to/godlikeme/im-tired-of-ai-videos-3pd1</link>
      <guid>https://dev.to/godlikeme/im-tired-of-ai-videos-3pd1</guid>
      <description>&lt;p&gt;I think Instagram and YouTube must have a button to hide Ai related content, what do you guys think? &lt;/p&gt;

</description>
      <category>discuss</category>
      <category>ai</category>
      <category>socialmedia</category>
      <category>machinelearning</category>
    </item>
    <item>
      <title>How to Clean Messy CSVs &amp; Excel Files in VS Code in 30 Seconds (With Live Pandas Sync)</title>
      <dc:creator>Amit</dc:creator>
      <pubDate>Mon, 16 Nov 2026 12:57:36 +0000</pubDate>
      <link>https://dev.to/godlikeme/how-to-clean-messy-csvs-excel-files-in-vs-code-in-30-seconds-with-live-pandas-sync-4bee</link>
      <guid>https://dev.to/godlikeme/how-to-clean-messy-csvs-excel-files-in-vs-code-in-30-seconds-with-live-pandas-sync-4bee</guid>
      <description>&lt;p&gt;Cleaning messy CSVs and Excel files usually means bouncing between Excel, Jupyter, and &lt;code&gt;df.head()&lt;/code&gt; prints just to catch typos like &lt;code&gt;"New Yrok"&lt;/code&gt;, mixed dates (&lt;code&gt;2025-01-05&lt;/code&gt; vs &lt;code&gt;12-Jan-2025&lt;/code&gt;), &lt;code&gt;$1,250.50&lt;/code&gt; strings, or &lt;code&gt;"true"&lt;/code&gt; / &lt;code&gt;"yes"&lt;/code&gt; / &lt;code&gt;"false"&lt;/code&gt; booleans.&lt;/p&gt;

&lt;p&gt;I built &lt;strong&gt;PandaScrub&lt;/strong&gt; (~440 KB VS Code extension + web studio) so you can inspect and clean datasets visually inside VS Code while generating real, editable &lt;strong&gt;Pandas / Polars Python code&lt;/strong&gt; side-by-side.&lt;/p&gt;




&lt;h3&gt;
  
  
  What it solves in ~30 seconds
&lt;/h3&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fiy45okbx02d042zoreo3.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fiy45okbx02d042zoreo3.png" alt=" " width="800" height="380"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Instant Profiling &amp;amp; Anomaly Detection&lt;/strong&gt;&lt;br&gt;
Open any &lt;code&gt;.csv&lt;/code&gt;, &lt;code&gt;.xlsx&lt;/code&gt;, &lt;code&gt;.parquet&lt;/code&gt;, &lt;code&gt;.json&lt;/code&gt;, &lt;code&gt;.sqlite&lt;/code&gt;, &lt;code&gt;.duckdb&lt;/code&gt;, or Python &lt;code&gt;DataFrame&lt;/code&gt; script right inside VS Code and immediately see null %, unique counts, data types, and zero-variance / mixed-format alerts.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;
&lt;p&gt;&lt;strong&gt;One-Click Visual Cleaning (No Boilerplate)&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Fuzzy Deduplicate &amp;amp; Typo Merge:&lt;/strong&gt; Clusters variants like &lt;code&gt;"New Yrok"&lt;/code&gt;, &lt;code&gt;"New Yorkk"&lt;/code&gt;, &lt;code&gt;"New Yrk"&lt;/code&gt; -&amp;gt; &lt;code&gt;"New York"&lt;/code&gt;.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Date &amp;amp; Currency Parsing:&lt;/strong&gt; Turns &lt;code&gt;$1,250.50&lt;/code&gt; into clean floats and standardizes mixed date formats (&lt;code&gt;YYYY-MM-DD&lt;/code&gt;, &lt;code&gt;DD/MM/YYYY&lt;/code&gt;, etc.).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Formula &amp;amp; Window Builder:&lt;/strong&gt; Create calculated columns (&lt;code&gt;lifetime_spend * 1.20&lt;/code&gt;), conditional &lt;code&gt;IF/THEN&lt;/code&gt; rules, or &lt;code&gt;GroupBy&lt;/code&gt; / running totals visually.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Boolean Cleanup:&lt;/strong&gt; Normalizes mixed &lt;code&gt;"true"&lt;/code&gt;, &lt;code&gt;"True"&lt;/code&gt;, &lt;code&gt;"yes"&lt;/code&gt;, &lt;code&gt;"false"&lt;/code&gt;, &lt;code&gt;"no"&lt;/code&gt;, &lt;code&gt;"1"&lt;/code&gt;, &lt;code&gt;"0"&lt;/code&gt; cleanly.&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Diff Changes + 2-Way Python Sync&lt;/strong&gt;&lt;br&gt;
Toggle &lt;strong&gt;Diff Changes&lt;/strong&gt; to highlight every modified cell against the original dataset, then click &lt;strong&gt;Insert Pipeline&lt;/strong&gt; to inject clean Pandas or Polars code straight into your &lt;code&gt;.py&lt;/code&gt; file. Edit Python and press &lt;code&gt;Ctrl+S&lt;/code&gt; -&amp;gt; the table hot-reloads live.&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;




&lt;h3&gt;
  
  
  Try It
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;VS Code Marketplace:&lt;/strong&gt; Search &lt;strong&gt;&lt;code&gt;PandaScrub&lt;/code&gt;&lt;/strong&gt; in VS Code Extensions&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Web Studio:&lt;/strong&gt; &lt;a href="https://pandascrub.dev" rel="noopener noreferrer"&gt;pandascrub.dev&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Community &amp;amp; Issues:&lt;/strong&gt; &lt;a href="https://github.com/Catalyst097/pandascrub-community" rel="noopener noreferrer"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fycte0ypx7ql7z1y3yzye.png" alt=" " width="707" height="675"&gt;&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;What's the most annoying data-cleaning step you keep repeating in Pandas? Happy to hear feedback!&lt;/p&gt;

</description>
      <category>python</category>
      <category>pandas</category>
      <category>vscode</category>
      <category>datascience</category>
    </item>
  </channel>
</rss>
