icp ip 网站备案/培训心得简短

考虑将数字列转换为浮点数,因为pd.read_html将Web数据作为字符串类型(即对象)读取.但在转换为浮点数之前,您需要将连字符替换为NaN：

import pandas as pd

import numpy as np

dfs = pd.read_html('https://www.google.com/finance?q=NASDAQ%3AGOOGL' +

'&fstype=ii&ei=9YBMWIiaLo29e83Rr9AM', flavor='html5lib')

xlWriter = pd.ExcelWriter('Output.xlsx', engine='xlsxwriter')

workbook = xlWriter.book

for i, df in enumerate(dfs):

for col in df.columns[1:]: # UPDATE ONLY NUMERIC COLS

df.loc[df[col] == '-', col] = np.nan # REPLACE HYPHEN WITH NaNs

df[col] = df[col].astype(float) # CONVERT TO FLOAT

df.to_excel(xlWriter, sheet_name='Sheet{}'.format(i))

xlWriter.save()