每天学点python数据分析软件-3.4 Pandas-Dataframe-IO操作

体验与学习 2019-12-11 00:00:00

import numpy as np

import pandas as pd

from pandas import Series,DataFrame

import webbrowser

link = "https://pandas./pandas-docs/version/0.20/io.html"

print(webbrowser.open(link))

df = pd.read_clipboard()

df.to_excel('df.xls',index=False)

df.to_csv('df.csv',index=False)

df.to_json('df.json')

df.to_html('df.html',index=False)

df2=pd.read_csv('df.csv')

print(df2)

df3 = pd.read_json('df.json')

print(df3)

体验与学习 2019-12-11 00:00:00

import numpy as np

import pandas as pd

from pandas import Series,DataFrame

import webbrowser

link = "https://pandas./pandas-docs/version/0.20/io.html"

print(webbrowser.open(link))

df = pd.read_clipboard()

df.to_excel('df.xls',index=False)

df.to_csv('df.csv',index=False)

df.to_json('df.json')

df.to_html('df.html',index=False)

df2=pd.read_csv('df.csv')

print(df2)

df3 = pd.read_json('df.json')

print(df3)