pandas和SQL数据分析实战视频教程
# -*- coding: utf-8 -*-
"""
Created on Mon Apr 4 18:04:06 2016
@author: Toby,qq:231469242,原创版权
"""
import csv,os,openpyxl
#获取所有excel文件名
def Get_excelFileNames():
excelFiles_list=[]
for excelFilename in os.listdir('.'):
if excelFilename.endswith('.xlsx') or excelFilename.endswith('.xls'):
excelFiles_list.append(excelFilename)
return excelFiles_list
'''
excelFiles_list
Out[17]: ['Book1.xlsx', 'Book2.xlsx', 'Book3.xlsx', 'Book4.