visualpython · minjk-bl · Sep 27, 2023 · Aug 26, 2023 · Aug 27, 2023 · Sep 13, 2023
diff --git a/build.sh b/build.sh
@@ -11,8 +11,8 @@
 #=============================================================================
 # Set version and replace it
 #=============================================================================
-VP_ORG_VER=2.4.8
-VP_NEW_VER=2.4.9
+VP_ORG_VER=2.4.9
+VP_NEW_VER=2.5.0
 
 # update version info
 grep -REil "VP_ORG_VER=.+$" colab/build.colab.sh jupyterlab/build.jupyterlab.sh jupyternotebook/build.jupyternotebook.sh | xargs sed -i "s/VP_ORG_VER=.\+$/VP_ORG_VER=${VP_ORG_VER}/g"

diff --git a/colab/build.colab.sh b/colab/build.colab.sh
@@ -11,8 +11,8 @@
 #=============================================================================
 # Replace Version
 #=============================================================================
-VP_ORG_VER=2.4.8
-VP_NEW_VER=2.4.9
+VP_ORG_VER=2.4.9
+VP_NEW_VER=2.5.0
 
 # update version info
 # update manifest version with new numbering for new version

diff --git a/colab/manifest.json b/colab/manifest.json
@@ -1,7 +1,7 @@
 {
     "name": "Visual Python for Colab",
     "description": "GUI-based Python code generator for Google Colab as an extension",
-    "version": "2.4.9",
+    "version": "2.5.0",
     "manifest_version": 3,
     "icons": {
         "48": "icon.png",

diff --git a/jupyterlab/build.jupyterlab.sh b/jupyterlab/build.jupyterlab.sh
@@ -11,8 +11,8 @@
 #=============================================================================
 # Replace Version and Basic Files
 #=============================================================================
-VP_ORG_VER=2.4.8
-VP_NEW_VER=2.4.9
+VP_ORG_VER=2.4.9
+VP_NEW_VER=2.5.0
 
 # update version info
 grep -REil "\"version\": \"${VP_ORG_VER}\"" package.json | xargs sed -i "s/\"version\": \"${VP_ORG_VER//\./\\.}\"/\"version\": \"${VP_NEW_VER}\"/g"

diff --git a/jupyterlab/package-lock.json b/jupyterlab/package-lock.json
diff --git a/jupyterlab/package.json b/jupyterlab/package.json
@@ -1,6 +1,6 @@
 {
   "name": "jupyterlab-visualpython",
-  "version": "2.4.9",
+  "version": "2.5.0",
   "description": "GUI-based Python code generator for Jupyter Lab as an extension",
   "keywords": [
     "jupyter",

diff --git a/jupyterlab/pyproject.toml b/jupyterlab/pyproject.toml
@@ -32,7 +32,7 @@ classifiers = [
     "Programming Language :: Python :: 3.9",
     "Programming Language :: Python :: 3.10",
 ]
-version = "2.4.9"
+version = "2.5.0"
 
 [project.license]
 file = "LICENSE"
@@ -92,7 +92,7 @@ file = [
 ]
 
 [tool.tbump.version]
-current = "2.4.9"
+current = "2.5.0"
 regex = "(?P<major>\\d+)\\.(?P<minor>\\d+)\\.(?P<patch>\\d+)((?P<channel>a|b|rc|.dev)(?P<release>\\d+))?"
 
 [tool.tbump.git]

diff --git a/jupyternotebook/build.jupyternotebook.sh b/jupyternotebook/build.jupyternotebook.sh
@@ -11,8 +11,8 @@
 #=============================================================================
 # Replace Version and Basic Files
 #=============================================================================
-VP_ORG_VER=2.4.8
-VP_NEW_VER=2.4.9
+VP_ORG_VER=2.4.9
+VP_NEW_VER=2.5.0
 
 # update version info
 grep -REil ${VP_ORG_VER//\./\\.} setup.py visualpython/js/com/com_Config.js visualpython/js/com/com_Const.js | xargs sed -i --follow-symlinks "s/${VP_ORG_VER//\./\\.}/${VP_NEW_VER}/g"

diff --git a/jupyternotebook/setup.py b/jupyternotebook/setup.py
@@ -10,7 +10,7 @@
 
 setup(
     name             = name,
-    version          = '2.4.9',
+    version          = '2.5.0',
     packages         = find_packages(),
     package_data     = {"": ["*"], 'visualpython' : ['visualpython.yaml', 'README.md']},
     scripts          = ['visualpython/bin/visualpy', 'visualpython/bin/visualpy.bat'],

diff --git a/visualpython/css/component/popupComponent.css b/visualpython/css/component/popupComponent.css
@@ -525,7 +525,7 @@
     height: 25px;
 }
 .vp-popup-frame .vp-accordian-box {
-    padding: 0px 15px 15px 0px;
+    padding: 0px 15px 0px 0px;
 }
 
 /* resizable handler */

diff --git a/visualpython/css/m_apps/frame.css b/visualpython/css/m_apps/frame.css
@@ -145,6 +145,7 @@
     top: 0;
     background-color: var(--vp-background-color);
     border-bottom: 1px solid var(--vp-border-gray-color);
+    border-right: 1px solid var(--vp-border-gray-color);
 
     text-align: right;
     text-overflow: ellipsis;
@@ -168,6 +169,12 @@
     /* background: var(--vp-light-gray-color); */
     /* background: rgba(66, 165, 245, 0.2); */
 }
+.vp-fe-table-column-isnumeric {
+    margin-right: 5px;
+    vertical-align: middle;
+    height: 15px;
+    line-height: 15px;
+}
 
 /* Row Hover */
 .vp-fe-table tbody tr:hover { 
@@ -302,6 +309,18 @@
     float: right;
     display: inline-block;
 }
+/* to datetime */
+.vp-inner-popup-todt-addcol-content {
+    display: grid;
+    row-gap: 5px;
+    max-height: 105px;
+}
+.vp-inner-popup-todt-addcol-head,
+.vp-inner-popup-todt-addcol-item {
+    display: grid;
+    grid-template-columns: 160px 160px auto;
+    column-gap: 5px;
+}
 
 /* UDF Editor - CodeMirror */
 .vp-fr-subset-box {

diff --git a/visualpython/css/m_visualize/seaborn.css b/visualpython/css/m_visualize/seaborn.css
@@ -47,17 +47,28 @@
     height: 100%;
 }
 .vp-tab-page-box.figure {
-    height: calc(100% - 30px);
+    height: 100%;
     align-content: baseline;
     grid-template-rows: 1fr;
+    overflow: hidden;
+}
+.vp-tab-page-box.figure > .vp-tab-page {
+    overflow: auto;
 }
 .vp-tab-page-box.plot {
-    height: calc(100% - 30px);
-    min-height: 352px;
+    /* height: calc(100% - 30px);
+    min-height: 352px; */
     align-content: baseline;
+    height: 100%;
+    max-height: 100%;
+    overflow: scroll;
+    padding: 15px 15px 0px 15px;
 }
 .vp-chart-plot-box {
     height: 100%;
+    display: grid;
+    grid-template-rows: 30px calc(100% - 30px);
+    overflow: auto;
 }
 .vp-chart-body {
     display: grid;
@@ -75,6 +86,14 @@
 .vp-chart-left-box, 
 .vp-chart-right-box {
     height: 100%;
+    display: grid;
+    grid-template-rows: 30px calc(100% - 30px);
+}
+.vp-chart-left-box {
+    overflow: auto;
+}
+.vp-chart-right-box {
+    overflow: hidden;
 }
 .vp-chart-preview-title {
     line-height: 30px;
@@ -86,7 +105,8 @@
 .vp-chart-preview-box {
     min-height: 352px;
     width: 100%;
-    height: calc(100% - 30px);
+    /* height: calc(100% - 30px); */
+    height: 100%;
 }
 .vp-chart-preview-content:empty::after {
     content: 'No preview image';

diff --git a/visualpython/data/m_library/pandasLibrary.js b/visualpython/data/m_library/pandasLibrary.js
@@ -6880,6 +6880,189 @@ define([
           },
         ]
       },
+      // ***
+      "pd_toParquet": {
+        "name": "To Parquet",
+        "library": "pandas",
+        "description": "DataFrame/Series to Parquet file",
+        "code": "${i0}.to_parquet(${path}${etc})",
+        "options": [
+          {
+            "name": "i0",
+            "label": "DataFrame",
+            "required": true,
+            "component": [
+              "data_select"
+            ],
+            "var_type": [
+              "DataFrame",
+              "Series"
+            ]
+          },
+          {
+            "name": "path",
+            "label": "File path/variable",
+            "required": true,
+            "type": "text"
+          }
+        ]
+      },
+      "pd_readParquet": {
+        "name": "Read Parquet",
+        "library": "pandas",
+        "description": "Parquet to pandas object",
+        "code": "${o0} = pd.read_parquet(${i0}${etc})",
+        "options": [
+          {
+            "name": "i0",
+            "label": "File path/object",
+            "required": true,
+            "type": "text",
+            "component": [
+              "file"
+            ]
+          },
+          {
+            "name": "o0",
+            "label": "Allocate to",
+            "output": true,
+            "component": [
+              "input"
+            ],
+            "value": "vp_df"
+          },
+        ]
+      },
+      "pa_readCsv": {
+        "name": "Read Csv as pyarrow",
+        "library": "pyarrow",
+        "description": "Csv to pandas object",
+        "code": "${o0} = pa.csv.read_csv(${i0}${etc}).to_pandas()",
+        "options": [
+          {
+            "name": "i0",
+            "label": "File path/object",
+            "required": true,
+            "type": "text",
+            "component": [
+              "file"
+            ]
+          },
+          {
+            "name": "o0",
+            "label": "Allocate to",
+            "output": true,
+            "component": [
+              "input"
+            ],
+            "value": "vp_df"
+          }
+        ]
+      },
+      "pa_toCsv": {
+        "name": "To Csv as pyarrow",
+        "library": "pyarrow",
+        "description": "DataFrame/Series to csv file",
+        "code": "pa.csv.write_csv(${i0}, ${path})",
+        "options": [
+          {
+            "name": "i0",
+            "label": "DataFrame",
+            "required": true,
+            "component": [
+              "data_select"
+            ],
+            "var_type": [
+              "DataFrame",
+              "Series"
+            ]
+          },
+          {
+            "name": "path",
+            "label": "File path/variable",
+            "required": true,
+            "type": "text"
+          }
+        ]
+      },
+      "pa_readJson": {
+        "name": "Read Json as pyarrow",
+        "library": "pyarrow",
+        "description": "Json to pyarrow object",
+        "code": "${o0} = pa.json.read_json(${i0}${etc}).to_pandas()",
+        "options": [
+          {
+            "name": "i0",
+            "label": "File path/object",
+            "required": true,
+            "type": "text",
+            "component": [
+              "file"
+            ]
+          },
+          {
+            "name": "o0",
+            "label": "Allocate to",
+            "output": true,
+            "component": [
+              "input"
+            ],
+            "value": "vp_df"
+          }
+        ]
+      },
+      "pa_readParquet": {
+        "name": "Read Parquet as pyarrow",
+        "library": "pyarrow",
+        "description": "Parquet to pandas object",
+        "code": "${o0} = pa.parquet.read_table(${i0}${etc}).to_pandas()",
+        "options": [
+          {
+            "name": "i0",
+            "label": "File path/object",
+            "required": true,
+            "type": "text",
+            "component": [
+              "file"
+            ]
+          },
+          {
+            "name": "o0",
+            "label": "Allocate to",
+            "output": true,
+            "component": [
+              "input"
+            ],
+            "value": "vp_df"
+          }
+        ]
+      },
+      "pa_toParquet": {
+        "name": "To Parquet as pyarrow",
+        "library": "pyarrow",
+        "description": "DataFrame/Series to Parquet file",
+        "code": "pa.parquet.write_table(${i0}, ${path})",
+        "options": [
+          {
+            "name": "i0",
+            "label": "DataFrame",
+            "required": true,
+            "component": [
+              "data_select"
+            ],
+            "var_type": [
+              "DataFrame",
+              "Series"
+            ]
+          },
+          {
+            "name": "path",
+            "label": "File path/variable",
+            "required": true,
+            "type": "text"
+          }
+        ]
+      },
     }
 
     return {