MySQLPandas: simple connector between MySQL(MariaDB) and Pandas
Project description
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
Author
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
MySQLPandas-0.0.15.tar.gz
(15.3 kB
view hashes)
Built Distribution
Close
Hashes for MySQLPandas-0.0.15-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1729dd8e41e626053de916f12f65f7bfcf8bcb7de49dec9f10af5a347fa067fe |
|
MD5 | e01eba6f40066b09412a99d01e3d7866 |
|
BLAKE2b-256 | 3e37ece87735ba708d62aeb786f84d2c7493bd319dbc46defe8f96dea8d82ce6 |