[PYTHON] Save pandas data in Excel format to data assets with Cloud Pak for Data (Watson Studio)

How to save the file to the data asset of the analysis project using project_lib [Another article](https://qiita.com/ttsuzuku/items/eac3e4bedc020da93bc1#%E3%83%87%E3%83%BC%E3% 82% BF% E8% B3% 87% E7% 94% A3% E3% 81% B8% E3% 81% AE% E3% 83% 87% E3% 83% BC% E3% 82% BF% E3% 81% AE% E4% BF% 9D% E5% AD% 98-% E5% 88% 86% E6% 9E% 90% E3% 83% 97% E3% 83% AD% E3% 82% B8% E3% 82% A7 I wrote it in% E3% 82% AF% E3% 83% 88), but it took some tricks to save it in Excel format. After a lot of research, stackoverflow's this article It was valid.

Here is an example that I actually tried.

Pandas dataframe used

#Sample data Iris
import pandas as pd
from sklearn.datasets import load_iris

iris = load_iris()
df = pd.DataFrame(iris.data, columns=iris.feature_names)
df['iris_type'] = iris.target_names[iris.target]


Let's save this data in Excel format. The flow is once saved as an Excel file in the environment with pandas.to_excel,

#Output to the environment once as an Excel file
filename = 'iris.xlsx'
df.to_excel(filename, index=False)
!ls -l

# -output-
# /home/wsuser/work
# total 12
# -rw-r-----. 1 wsuser watsonstudio 8737 May 28 06:53 iris.xlsx

Read it as an io byte stream and save it in your analysis project with project_lib.

from project_lib import Project
project = Project.access()

import io

with open(filename, 'rb') as z:
        data = io.BytesIO(z.read())
        project.save_data(filename, data, set_project_asset=True, overwrite=True)

Make sure it was saved in your analysis project. image.png

Just in case, I will download it and take a look at the contents. image.png You have successfully saved 150 lines of Iris data in Excel format.

Recommended Posts

Save pandas data in Excel format to data assets with Cloud Pak for Data (Watson Studio)
How to change python version of Notebook in Watson Studio (or Cloud Pak for Data)
Deploy functions with Cloud Pak for Data
Ingenuity to handle data with Pandas in a memory-saving manner
Output log file with Job (Notebook) of Cloud Pak for Data
[Pandas] I tried to analyze sales data with Python [For beginners]
Eliminate garbled Japanese characters in matplotlib graphs in Cloud Pak for Data Notebook
Cloud Pak for Data object operation example in Python (WML client, project_lib)
Convert Excel data to JSON with python
Working with 3D data structures in pandas
Best practices for messing with data with pandas
Execute API of Cloud Pak for Data analysis project Job with environment variables
Convert Mobile Suica usage history PDF to pandas Data Frame format with tabula-py
How to replace with Pandas DataFrame, which is useful for data analysis (easy)
The first step to log analysis (how to format and put log data in Pandas)
Try to aggregate doujin music data with pandas
I tried to save the data with discord
Save data to flash with STM32 Nucleo Board
Clean up the Cloud pak for Data deployment space
How to convert horizontally held data to vertically held data with pandas
How to access with cache when reading_json in pandas
Save TOPIX time series in pickle, csv, Excel format
Convert numeric variables to categorical with thresholds in pandas
How to extract non-missing value nan data with pandas
"Import Error: Install xlrd> = 0.9.0 for Excel support" error in Pandas. Resolved by changing to use openpyxl