Skip to Main Content
APEX AppLab - Demo
Install App
APEX_PUBLIC_ROUTER
---
Sign Out
Charts
Charts
Markdown
Markdown
APEX New Features
APEX New Features
Redwood
Redwood
Calendar
Calendar
Success Messages
Success Messages
Multiple Process Success messages
Multiple Process Success messages
APEX_ITEM dropdown
APEX_ITEM dropdown
APEX_Debug new features 21.2
APEX_Debug new features 21.2
Translations
Translations
Generating iCal file
Generating iCal file
UI
UI
Grid layout
CSS Yeti
JS Async
JS Async
Chat
Chat
Twitter Threads
Twitter Threads
Email validation
Email validation
Validations
Validations
three.js
three.js
PyScript
PyScript
APEX Instance vars
APEX Instance vars
Painting Report cells
Painting Report cells
Upload image preview
Upload image preview
Maps and Spatial
Maps and Spatial
US Stadiums Map
Understanding Maps
Geocoding
Live tracking
75k points Map - no index
75k points Map - spatial index
Hashnode Blog
Hashnode Blog
Demo Data Load
Demo Data Load
Demo File Upload Form
Demo File Upload Form
Built-in Datasets
Built-in Datasets
BBC Results
BBC Results
Conference Cards UKOUG:23
Conference Cards UKOUG:23
Conference Cards Demo
Conference Cards Demo
APEX World 24
APEX World 24
JSON Viewer
JSON Viewer
PyScript
Breadcrumb
Markdown
Python Pandas
- pandas
import pandas as pd data = { "Duration":{ "0":60, "1":60, "2":60, "3":45, "4":45, "5":60 }, "Pulse":{ "0":110, "1":117, "2":103, "3":109, "4":117, "5":102 }, "Maxpulse":{ "0":130, "1":145, "2":135, "3":175, "4":148, "5":127 }, "Calories":{ "0":409, "1":479, "2":340, "3":282, "4":406, "5":300 } } df = pd.DataFrame(data) print(df) print(df.corr())
Python Pandas
- pandas
import pandas as pd data = [ { "rk":"1", "LGRK":"1", "MP":38 }, { "rk":"2", "LGRK":"2", "MP":38 }, { "rk":"3", "LGRK":"1", "MP":34 }, { "rk":"4", "LGRK":"1", "MP":38 }, { "rk":"5", "LGRK":"1", "MP":38 }, { "rk":"6", "LGRK":"1", "MP":38 }, { "rk":"7", "LGRK":"2", "MP":38 }, { "rk":"8", "LGRK":"3", "MP":38 }, { "rk":"9", "LGRK":"2", "MP":34 }, { "rk":"10", "LGRK":"3", "MP":38 }, { "rk":"11", "LGRK":"2", "MP":38 }, { "rk":"12", "LGRK":"3", "MP":34 }, { "rk":"13", "LGRK":"4", "MP":38 }, { "rk":"14", "LGRK":"2", "MP":38 }, { "rk":"15", "LGRK":"3", "MP":38 }, { "rk":"16", "LGRK":"4", "MP":38 }, { "rk":"17", "LGRK":"4", "MP":38 }, { "rk":"18", "LGRK":"3", "MP":38 }, { "rk":"19", "LGRK":"5", "MP":38 }, { "rk":"20", "LGRK":"4", "MP":38 }, { "rk":"21", "LGRK":"5", "MP":38 }, { "rk":"22", "LGRK":"4", "MP":34 }, { "rk":"23", "LGRK":"5", "MP":38 }, { "rk":"24", "LGRK":"5", "MP":38 }, { "rk":"25", "LGRK":"5", "MP":34 }, { "rk":"26", "LGRK":"6", "MP":38 }, { "rk":"27", "LGRK":"6", "MP":38 }, { "rk":"28", "LGRK":"7", "MP":38 }, { "rk":"29", "LGRK":"7", "MP":38 }, { "rk":"30", "LGRK":"6", "MP":38 }, { "rk":"31", "LGRK":"6", "MP":34 }, { "rk":"32", "LGRK":"8", "MP":38 }, { "rk":"33", "LGRK":"7", "MP":38 }, { "rk":"34", "LGRK":"8", "MP":38 }, { "rk":"35", "LGRK":"7", "MP":34 }, { "rk":"36", "LGRK":"6", "MP":38 }, { "rk":"37", "LGRK":"7", "MP":38 }, { "rk":"38", "LGRK":"9", "MP":38 }, { "rk":"39", "LGRK":"8", "MP":38 }, { "rk":"40", "LGRK":"10", "MP":38 }, { "rk":"41", "LGRK":"9", "MP":38 }, { "rk":"42", "LGRK":"8", "MP":38 }, { "rk":"43", "LGRK":"8", "MP":34 }, { "rk":"44", "LGRK":"9", "MP":34 }, { "rk":"45", "LGRK":"9", "MP":38 }, { "rk":"46", "LGRK":"10", "MP":38 }, { "rk":"47", "LGRK":"10", "MP":38 }, { "rk":"48", "LGRK":"11", "MP":38 }, { "rk":"49", "LGRK":"10", "MP":34 }, { "rk":"50", "LGRK":"11", "MP":38 }, { "rk":"51", "LGRK":"12", "MP":38 }, { "rk":"52", "LGRK":"9", "MP":38 }, { "rk":"53", "LGRK":"11", "MP":38 }, { "rk":"54", "LGRK":"12", "MP":38 }, { "rk":"55", "LGRK":"11", "MP":34 }, { "rk":"56", "LGRK":"12", "MP":34 }, { "rk":"57", "LGRK":"13", "MP":34 }, { "rk":"58", "LGRK":"10", "MP":38 }, { "rk":"59", "LGRK":"11", "MP":38 }, { "rk":"60", "LGRK":"12", "MP":38 }, { "rk":"61", "LGRK":"13", "MP":38 }, { "rk":"62", "LGRK":"13", "MP":38 }, { "rk":"63", "LGRK":"14", "MP":38 }, { "rk":"64", "LGRK":"13", "MP":38 }, { "rk":"65", "LGRK":"14", "MP":34 }, { "rk":"66", "LGRK":"12", "MP":38 }, { "rk":"67", "LGRK":"13", "MP":38 }, { "rk":"68", "LGRK":"14", "MP":38 }, { "rk":"69", "LGRK":"14", "MP":38 }, { "rk":"70", "LGRK":"14", "MP":38 }, { "rk":"71", "LGRK":"15", "MP":38 }, { "rk":"72", "LGRK":"15", "MP":38 }, { "rk":"73", "LGRK":"17", "MP":38 }, { "rk":"74", "LGRK":"16", "MP":38 }, { "rk":"75", "LGRK":"16", "MP":38 }, { "rk":"76", "LGRK":"15", "MP":38 }, { "rk":"77", "LGRK":"18", "MP":38 }, { "rk":"78", "LGRK":"17", "MP":38 }, { "rk":"79", "LGRK":"15", "MP":34 }, { "rk":"80", "LGRK":"16", "MP":34 }, { "rk":"81", "LGRK":"15", "MP":38 }, { "rk":"82", "LGRK":"16", "MP":38 }, { "rk":"83", "LGRK":"16", "MP":38 }, { "rk":"84", "LGRK":"17", "MP":38 }, { "rk":"85", "LGRK":"18", "MP":38 }, { "rk":"86", "LGRK":"19", "MP":38 }, { "rk":"87", "LGRK":"18", "MP":38 }, { "rk":"88", "LGRK":"17", "MP":34 }, { "rk":"89", "LGRK":"20", "MP":38 }, { "rk":"90", "LGRK":"19", "MP":38 }, { "rk":"91", "LGRK":"20", "MP":38 }, { "rk":"92", "LGRK":"17", "MP":38 }, { "rk":"93", "LGRK":"18", "MP":38 }, { "rk":"94", "LGRK":"19", "MP":38 }, { "rk":"95", "LGRK":"20", "MP":38 }, { "rk":"96", "LGRK":"19", "MP":38 }, { "rk":"97", "LGRK":"20", "MP":38 }, { "rk":"98", "LGRK":"18", "MP":34 } ] df = pd.DataFrame(data) print(df) print(df.corr())
Python Chart
Price
Date
- numpy - matplotlib
import numpy as np import matplotlib.pyplot as plt # get Page Item P23_PRICE ul_element = Element("P23_PRICE") # transfer value from Page Item to numpy array arr_price = np.fromstring(ul_element.value, dtype=float, sep=',') # get Page Item P23_Date ul_date = Element("P23_DATE") # get Page Item value date_list = ul_date.value # transfer value from Page Item to array arr_date = date_list.split(",") # prepare the plot fig, ax = plt.subplots(figsize=(15, 8)) # add the arrays to the plot ax.plot(arr_date, arr_price) # format the plot fig.autofmt_xdate() # display the plot plt