Web3 Engineering Docs
  • 👋Welcome to the W3E docs
  • Overview
    • Product overview
    • 🤿Indexer
      • Database tables
      • Clickhouse queries (DBeaver)
      • Query Timeout
      • Duplicate rows
    • 🤿On-chain AI helper
    • 🤿Reliable SOL Yield
      • Staking SOL basics
    • 🤿Data Streaming Node
    • 🤿Consulting services
    • 🤿On-chain community
    • 🔑Contact info
Powered by GitBook
On this page
  1. Overview
  2. Indexer

Duplicate rows

PreviousQuery TimeoutNextOn-chain AI helper

Last updated 1 month ago

Due to the way the transaction parser works, duplicate rows may sometimes appear in the database. This is not an error but rather a feature of the parsing process, which sometimes processes the same transaction multiple times for accuracy.

In Python, duplicates can easily be removed using the drop_duplicates function.

Learn more here:

🤿
https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.drop_duplicates.html