<?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: Python Tools Lab</title>
    <description>The latest articles on DEV Community by Python Tools Lab (@phytontoolsdev).</description>
    <link>https://dev.to/phytontoolsdev</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%2F4250080%2Fbd5d78f5-1218-47d5-ac55-200c9d1cae9f.png</url>
      <title>DEV Community: Python Tools Lab</title>
      <link>https://dev.to/phytontoolsdev</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/phytontoolsdev"/>
    <language>en</language>
    <item>
      <title>How to Merge 100s of Excel &amp; CSV Files in 5 Lines of Python</title>
      <dc:creator>Python Tools Lab</dc:creator>
      <pubDate>Thu, 19 Nov 2026 22:14:11 +0000</pubDate>
      <link>https://dev.to/phytontoolsdev/how-to-merge-100s-of-excel-csv-files-in-5-lines-of-python-35le</link>
      <guid>https://dev.to/phytontoolsdev/how-to-merge-100s-of-excel-csv-files-in-5-lines-of-python-35le</guid>
      <description>&lt;p&gt;Copying and pasting rows across dozens of daily or monthly CSV and Excel exports is one of the fastest ways to waste hours of your week.&lt;/p&gt;

&lt;p&gt;With Python and Pandas, you can combine every CSV and Excel file in a folder into one clean master workbook in seconds:&lt;/p&gt;


&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;import glob, os, pandas as pd

&lt;p&gt;all_files = glob.glob("./raw_files/&lt;em&gt;.csv") + glob.glob("./raw_files/&lt;/em&gt;.xlsx")&lt;br&gt;
frames = []&lt;/p&gt;

&lt;p&gt;for f in all_files:&lt;br&gt;
    df = pd.read_csv(f) if f.endswith(".csv") else pd.read_excel(f)&lt;br&gt;
    df["Source_File"] = os.path.basename(f)&lt;br&gt;
    frames.append(df)&lt;/p&gt;

&lt;p&gt;pd.concat(frames, ignore_index=True).to_excel("merged_master_data.xlsx", index=False)&lt;br&gt;
&lt;/p&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;
&lt;h3&gt;
&lt;br&gt;
  &lt;br&gt;
  &lt;br&gt;
  Want 4 Complete Excel &amp;amp; CSV Automation Scripts?&lt;br&gt;
&lt;/h3&gt;

&lt;p&gt;If you need ready-to-run templates for merging spreadsheets, cleaning messy currencies/duplicates, generating styled executive Excel reports, and catching fuzzy name typos, grab The No-BS Python Excel &amp;amp; CSV Automation Kit (50% launch discount with code EXCEL50):&lt;/p&gt;

&lt;p&gt;Download the Playbook &amp;amp; 4 Templates (50% OFF): &lt;a href="https://tugrulian8.gumroad" rel="noopener noreferrer"&gt;https://tugrulian8.gumroad&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>python</category>
      <category>randas</category>
      <category>excel</category>
      <category>automation</category>
    </item>
    <item>
      <title>Extract Any HTML Table to Excel in 3 Lines of Python</title>
      <dc:creator>Python Tools Lab</dc:creator>
      <pubDate>Thu, 19 Nov 2026 21:48:43 +0000</pubDate>
      <link>https://dev.to/phytontoolsdev/extract-any-html-table-to-excel-in-3-lines-of-python-2f03</link>
      <guid>https://dev.to/phytontoolsdev/extract-any-html-table-to-excel-in-3-lines-of-python-2f03</guid>
      <description>&lt;p&gt;You don't need complex regex or nested BeautifulSoup loops to scrape financial, sports, or statistics tables.&lt;/p&gt;

&lt;p&gt;With pandas, you can extract every HTML table on a webpage in 3 lines of code:&lt;/p&gt;


&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;import pandas as pd&lt;br&gt;
tables = pd.read_html("&lt;a href="https://en.wikipedia.org/wiki/List_of_countries_by_GDP_(nominal)%22" rel="noopener noreferrer"&gt;https://en.wikipedia.org/wiki/List_of_countries_by_GDP_(nominal)"&lt;/a&gt;)&lt;br&gt;
tables[0].to_excel("gdp_data.xlsx", index=False)&lt;br&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;
&lt;h3&gt;
&lt;br&gt;
  &lt;br&gt;
  &lt;br&gt;
  Want More Production-Ready Scraping Templates?&lt;br&gt;
&lt;/h3&gt;

&lt;p&gt;If you need full scripts for static catalogs, dynamic JavaScript/Playwright scrolling, and anti-block User-Agent rotation, check out The No-BS Python Web Scraping Playbook (50% launch discount):&lt;/p&gt;

&lt;p&gt;Download the Playbook &amp;amp; 4 Templates: &lt;a href="https://tugrulian8.gumroad.com/l/ktiqff/LAUNCH50" rel="noopener noreferrer"&gt;https://tugrulian8.gumroad.com/l/ktiqff/LAUNCH50&lt;/a&gt;&lt;/p&gt;

</description>
      <category>python</category>
      <category>pandas</category>
      <category>webscraping</category>
      <category>tutorial</category>
    </item>
    <item>
      <title>How to Scrape Dynamic JavaScript Websites with Python and Playwright (2026 Guide)</title>
      <dc:creator>Python Tools Lab</dc:creator>
      <pubDate>Tue, 17 Nov 2026 14:50:59 +0000</pubDate>
      <link>https://dev.to/phytontoolsdev/how-to-scrape-dynamic-javascript-websites-with-python-and-playwright-2026-guide-n38</link>
      <guid>https://dev.to/phytontoolsdev/how-to-scrape-dynamic-javascript-websites-with-python-and-playwright-2026-guide-n38</guid>
      <description>&lt;p&gt;Most web scraping tutorials show you how to use requests and BeautifulSoup. That works great for static HTML, but modern websites built with React, Vue, or Next.js load data dynamically via JavaScript—leaving you with empty tags.&lt;/p&gt;

&lt;p&gt;Here is a clean, production-ready template using Playwright that renders JavaScript, handles infinite scrolling, and exports directly to CSV:&lt;/p&gt;


&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;import time&lt;br&gt;
import pandas as pd&lt;br&gt;
from playwright.sync_api import sync_playwright

&lt;p&gt;TARGET_URL = "&lt;a href="https://quotes.toscrape.com/js/" rel="noopener noreferrer"&gt;https://quotes.toscrape.com/js/&lt;/a&gt;"&lt;br&gt;
WAIT_SELECTOR = "div.quote"&lt;/p&gt;

&lt;p&gt;with sync_playwright() as p:&lt;br&gt;
    browser = p.chromium.launch(headless=True)&lt;br&gt;
    page = browser.new_page()&lt;br&gt;
    page.goto(TARGET_URL, wait_until="networkidle")&lt;br&gt;
    page.wait_for_selector(WAIT_SELECTOR)&lt;/p&gt;
&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;for _ in range(3):
    page.evaluate("window.scrollTo(0, document.body.scrollHeight)")
    time.sleep(2)

items = page.query_selector_all(WAIT_SELECTOR)
data = [{"Quote": i.query_selector("span.text").inner_text()} for i in items]
browser.close()
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;
&lt;p&gt;pd.DataFrame(data).to_csv("output.csv", index=False)&lt;br&gt;
&lt;/p&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;
&lt;h3&gt;
&lt;br&gt;
  &lt;br&gt;
  &lt;br&gt;
  Want the Complete Playbook &amp;amp; 4 Ready-to-Use Templates?&lt;br&gt;
&lt;/h3&gt;

&lt;p&gt;If you want the full step-by-step guide—including static catalog scrapers, HTML table extractors, and anti-block User-Agent rotation scripts—grab The No-BS Python Web Scraping Playbook here:&lt;/p&gt;

&lt;p&gt;Download the Playbook &amp;amp; Python Templates: &lt;a href="https://tugrulian8.gumroad.com/l/ktiqff" rel="noopener noreferrer"&gt;https://tugrulian8.gumroad.com/l/ktiqff&lt;/a&gt;&lt;/p&gt;

</description>
      <category>phyton</category>
      <category>webscraping</category>
    </item>
  </channel>
</rss>
