Python与数据科学实战课程——第三章Pandas：Dataframe_IO

import numpy as np
import pandas as pd
from pandas import Series,DataFrame

读写到粘贴板中

import webbrowser
link = "http://pandas.pydata.org/pandas-docs/version/0.20/io.html"
webbrowser.open(link)

True

df1 = pd.read_clipboard()
df1

	Format Type	Data Description	Reader	Writer
0	text	CSV	read_csv	to_csv
1	text	JSON	read_json	to_json
2	text	HTML	read_html	to_html
3	text	Local clipboard	read_clipboard	to_clipboard
4	binary	MS Excel	read_excel	to_excel
5	binary	HDF5 Format	read_hdf	to_hdf
6	binary	Feather Format	read_feather	to_feather
7	binary	Msgpack	read_msgpack	to_msgpack
8	binary	Stata	read_stata	to_stata
9	binary	SAS	read_sas
10	binary	Python Pickle Format	read_pickle	to_pickle
11	SQL	SQL	read_sql	to_sql
12	SQL	Google Big Query	read_gbq	to_gbq

import sys #查看Python版本
print (sys.version) 
print (sys.version_info)

3.6.2 |Continuum Analytics, Inc.| (default, Jul 20 2017, 12:30:02) [MSC v.1900 64 bit (AMD64)]
sys.version_info(major=3, minor=6, micro=2, releaselevel=‘final’, serial=0)

df1.to_clipboard   #写入粘贴板，用于复制到E