In this notebook, I show you how to combine rows that are near-duplicates and remove true duplicate rows in Pandas. I recently ran into this problem while doing some data cleaning. I decided to simply combine the similar rows into one row. The below notebook details how to accomplish merging the rows into one.
Continue reading “How to Combine Duplicate or Similar Rows in Pandas”Tag: pandas
SQL Import Excel File to Table with Python Pandas
If you’re looking for a simple script to extract data from an excel file and put it in an SQL table, you’ve come to the right place. In this article, I will show you how to use python pandas and sqlalchemy to import an excel file to a SQL database (MySQL) in a free, fast and flexible manner. The same method also works for SQLite or other SQL databases, but the connection details will be different.