# -*- 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')