Python 数据分析三剑客(CSV-Excel-Mysql)

1、CSV

# -*- coding: utf-8 -*-
import os,re,sys,time,csv

with open('./csv_tutorial.csv','a') as fw:
    writer = csv.writer(fw,quoting=csv.QUOTE_NONNUMERIC)
    writer.writerow(["c1","c2","c3"])
    for x in range(10):
        writer.writerow([x,chr(ord('A') + x), 'abc'])

with open('./csv_tutorial.csv','r') as fr:
    rows = csv.DictReader(fr)
    for row in rows:
        print(row)

 

2、Excel

#!/usr/bin/python

# -*- coding: utf-8 -*-

import pandas as pd
import os

pd.set_option('display.max_columns',5)
pd.set_option('display.max_rows',6)

df = pd.read_excel('./0614.xlsx')
print(df)

ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.

Setting>>>>>Projcet Interpreter>>>>>>安装下插件

 

 

 

 　　等待安装成功，必要的时候需要更改下镜像源。

 

 

 

3、Mysql

　　数据库的相关内容，我之前已经在另外一篇文章写过，链接附上。

　　https://www.cnblogs.com/SliverLee/p/12502576.html