Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Currently dataiku has a "copy rows to json" feature, which is great.
Is there a way to copy multiple rows instead of just one row in explore?
Also, would it be possible to highlight/select and copy to clipboard cells in explore, just like in Excel?
No, it's not possible. What's the use case? What are you trying to achieve?
i copy snippets of data for stakeholder ad-hoc requests. I could do screenshots but they are not optimal for obvious reasons.
Well I don't know about you but I never share a JSON copy/paste object with a stakeholder. I usually use Excel files for adhoc requests. So why not get that from the start rather than using copy/paste features that do not fit your use case properly? For instance the following code run in a Jupyter notebook will produce a CSV download link of a data frame read from a Dataiku dataset. The file is not even persisted so it's adhoc.
from IPython.display import display, HTML
import dataiku
import base64
display(HTML("<style>.container { width:100% !important; }</style>"))
dataset = dataiku.Dataset("some_dataset_id")
dataset_df = dataset.get_dataframe()
def create_download_link( df, title = "Download CSV file", filename = "data.csv"):
csv = df.to_csv()
b64 = base64.b64encode(csv.encode())
payload = b64.decode()
html = '<a download="{filename}" href="data:text/csv;base64,{payload}" target="_blank">{title}</a>'
html = html.format(payload=payload,title=title,filename=filename)
return HTML(html)
create_download_link(dataset_df)