Python大数据(2019-07-13至2019-07-22实习培训)

附python3操作MySQL（增删改查、事务）导入支持库In [1020]:import numpy as np import matplotlib.pyplot as plt import matplotlib as mpl import pandas as pd from pandas import Series, DataFrame #在GUI中显示 # %matplotlib tk #在行内显示(默认) %matplotlib inline mpl.rcParams['font.sans-serif'] = ['SimHei'] mpl.rcParams['axes.unicode_minus'] = False载入数据 合并数据 data_objIn [226]:users_df = pd.read_csv('./data/users.dat', sep='::', engine='python', names=['UserID', 'Gender', 'Age', 'Occupation', 'Zip-code']) movies_df = pd.read_csv

默认分类 · 2019-07-22 · 295 人浏览
Python大数据(2019-07-13至2019-07-22实习培训)

python3-MySQL增删改查、事务

python3操作MySQL数据库需要用到pymysql库如果没有安装pymysql库，在命令行下执行如下命令安装pip3 install PyMySQL不支持pip命令参考菜鸟教程的安装方法https://www.runoob.com/python3/python3-mysql.html先发一下实验用的表CREATE TABLE `chat_vcode` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `phone` varchar(255) DEFAULT NULL, `vcode` varchar(255) DEFAULT NULL, `code_time` bigint(13) DEFAULT NULL, `inuse` int(2) unsigned NOT NULL COMMENT '0无效 1有效', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;安装后pymysql库后，先引用import pym

默认分类 · 2019-07-08 · 289 人浏览
python3-MySQL增删改查、事务
2017 - 2026 Bill. All Rights Reserved.
皖ICP备2021000564号-1
Theme Jasmine by Kent Liao And Bill

本站由提供云存储服务