python基础课程（二）：类复习、numpy（array，矩阵）、pandas(Series、DataFrame)、pandas(txt、cvs、excel、mysql）读取文件

# -*- coding: utf-8 -*-
"""
Created on Mon Feb 25 21:52:12 2019
@author: wangzhanjun
"""

class  CommTool(object):
    className=''
    def __init__(self,pClassName):
        self.className=pClassName
        
 
    def getClassName(self):
        return self.className
        
def main():
    if __name__ == '__main__':
        main()
#        commTool=CommTool('CommToolClass')
#        print(commTool.getClassName())

commTool=CommTool('CommToolClass')
print(commTool.getClassName())
        

"""

np array
"""
import numpy as np
data1=[1,2,3,4,5]
array1=np.array(data1)
array1

data2=[[1,2,3],[4,5,6]]
array2=np.array(data2)
array2
array2.dtype

array1.astype('str')

from pandas import Series
X=Series(['a',2,'螃蟹'],index=[1,2,3])

X

from pandas import DataFrame
df=DataFrame({
        'age':Series([1,2,3]),
        'name':Series(['wzj','zz','wye'])
        },index=[0,1,2])

df

fileBathPath='K:\\demodata\\'
dataFile01='rz.txt'#班级成绩
dataFile02='rz.csv'

from pandas import read_table
df1=read_table(fileBathPath+dataFile01,sep=" ")
df1.head()
df1.tail(10)

from pandas import read_csv
df2=read_csv(fileBathPath+dataFile02,sep=",")
df2
df2.count

from pandas import read_excel
dataFile03='i_nuc.xls'
df3=read_excel(fileBathPath+dataFile03,sheetname='Sheet3')
df3

# mysql需要安装pymysql包,方法：pip install pymysql

import pandas as pd
import pymysql
#dict字典类型
config={'host':'127.0.0.1',
        'port':3306,
        'user':'root',
        'password':'root',
        'db':'test',
        'charset':'utf8'
        }
dbconn=pymysql.connect(**config)#**代表是动态参数，个数根据实际带入进行运算
sqlCmd="select * from user"
a=pd.read_sql(sqlCmd,dbconn)
dbconn.close()
b=a.head()
print(b)

"""
导出数据

"""
a.to_csv('K:\\demodata\\001.csv')
a.to_excel('K:\\demodata\\002.xlsx')