Dashboard本来是做数据分析用的工具,但是如果想把数据下载下来,要怎么做呢?
我去官网没有说明如何下载数据,后来在官方论坛上看到了解决方案:
https://community.plot.ly/t/download-raw-data/4700
在回帖里面,找 chriddyp 的总结,可以实现这个目标,下面是截图:
这个是很早以前的库了,按照他原来的做法,提示我找不到urllib里面的quote 函数,经过我的查找,发现这库已经重新规划一下,里面增加了很多新内容,所以,这个函数放在一个子域里面,我修改后的代码是这样的:
import dash
import dash_core_components as dcc
import dash_html_components as html
import pandas as pd
import urllib.parse as url_parse # 这里做了修改
df = pd.DataFrame({
'a': [1, 2, 3, 4],
'b': [2, 1, 5, 6],
'c': ['x', 'x', 'y', 'y']
})
def generate_table(dataframe, max_rows=10):
return html.Table(
# Header
[html.Tr([html.Th(col) for col in dataframe.columns])] +
# Body
[html.Tr([
html.Td(dataframe.iloc[i][col]) for col in dataframe.columns
]) for i in range(min(len(dataframe), max_rows))]
)
app = dash.Dash(__name__)
app.css.append_css({"external_url": "https://codepen.io/chriddyp/pen/bWLwgP.css"})
app.layout = html.Div([
html.Label('Filter'),
dcc.Dropdown(
id='field-dropdown',
options=[
{'label': i, 'value': i} for i in
(['all'] + list(df['c'].unique()))],
value='all'
),
html.Div(id='table'),
html.A(
'Download Data',
id='download-link',
download="rawdata.csv",
href="",
target="_blank"
)
])
def filter_data(value):
if value == 'all':
return df
else:
return df[df['c'] == value]
@app.callback(
dash.dependencies.Output('table', 'children'),
[dash.dependencies.Input('field-dropdown', 'value')])
def update_table(filter_value):
dff = filter_data(filter_value)
return generate_table(dff)
@app.callback(
dash.dependencies.Output('download-link', 'href'),
[dash.dependencies.Input('field-dropdown', 'value')])
def update_download_link(filter_value):
dff = filter_data(filter_value)
csv_string = dff.to_csv(index=False, encoding='utf-8')
csv_string = "data:text/csv;charset=utf-8," + url_parse.quote(csv_string) # 这里原本提示找不到quote,是因为放到子域parse里面了
return csv_string
if __name__ == '__main__':
app.run_server(debug=True)