Python3 - Pandas: Data Input and Output

先得安装这两个：

pip install xlrd==1.2.0
pip install lxml

代码如下：

import pandas as pd
import urllib.request
import ssl
import numpy as np

print('***** Read CSV *****')
df = pd.read_csv('example.csv')
print(df)
print('\n')

df.to_csv('My_output')
print(pd.read_csv('My_output'))
print('\n')
df.to_csv('My_output', index=False)
print(pd.read_csv('My_output'))
print('\n')

print('**** Read xlsx *****')
df_excel = pd.read_excel('ExcelSample.xlsx', sheet_name='Sheet1') # 因为xlrd升级了，不支持读取xlsx. 所以只能pip install xlrd==1.2.0
print(df_excel)
print('\n')

# print("**** Read HTML ****")
# data = pd.read_html('http://www.fdic.gov/resources/resolutions/bank-failures/failed-bank-list/banklist.html')  # pip install lxml
# print(data)

# ssl._create_default_https_context = ssl._create_unverified_context
# response = urllib.request.urlopen('https://www.fdic.gov/resources/resolutions/bank-failures/failed-bank-list/banklist.html')
# print(response.read().decode('utf-8'))

print("**** SQL *****")
from sqlalchemy import create_engine

engine = create_engine('sqlite:///:memory:')
df.to_sql('my_table',engine)
sqldf = pd.read_sql('my_table', con=engine)
print(sqldf)

结果如下：
example.csv 文件：

如果觉得不错，就点赞或者关注或者留言~~
谢谢~ ~