MySQLPandas 0.0.15

MySQLPandas: simple connector between MySQL(MariaDB) and Pandas

MySQLPandas

Overview

Simple connector between MySQL(MariaDB) and Pandas

Description

This tool is primarily intended to help Python users easily handle databases. It uses Pandas as its base, so it should be easy to use even for those who are not familiar with databases. The tool supports MySQL or MariaDB as the database engine.

Demo

• Make new table and install dataframe or csv

from MySQLPandas.core import MySQLPandas
with MySQLPandas("hoge","hoge_db",initfile_path="hoge.ini") as obj:
    obj.makeTable("sample_table",df_path="sample.csv")
    obj.showTableinfo("sample_table")
    obj.insertRecord("sample_table",df_path="sample.csv")

About other functions, see here.

Requirement

• MySQL(MariaDB)
  The version of Auther's MariaDB is 5.5.68-MariaDB MariaDB Server.
  Don't try the newest version so please check your MariaDB version.
• Pandas <= 1.5.3
• Python 3.*
• mysql-connector-python <= 8.0.29

Pages

See here.

Install

Install through pip.

pip install MySQLPandas

Licence

GNU GPLv2

Author

Sota Nakashima