Introducing Python in LibreOffice Calc
You can use Python INSIDE LibreOffice Calc now 😱 In this video I'll introduce this game changing new functionality of working with Python inside LibreOffice Calc. Is Python in Calc for non-programmers? Can everyday data analysts make use of it? We will explore the answers these questions in this video.
🐍 What You'll Learn:
Entering Python Mode in Calc: Master the basics of switching to Python mode in your Calc Sheet.
Data Frame Creation: Understand how to create and manipulate Data Frames from Calc data, providing a robust structure for analysis.
Custom Python Formulas: Explore the power of custom Python formulas in Calc, expanding your analytical capabilities beyond traditional Calc functions.
Advanced Charting: Dive into creating dynamic charts within Calc cells using Python, including enhanced data visualization options.
Chapters:
00:00 Intro
00:23 Download LibrePythonista Extension
01:19 Install LibrePythonista Extension
03:11 Enable Macros
04:27 Enabling Menus and Toolbar
04:49 How to get into Python Mode
05:31 Sending Data to Python
07:16 PY.C Custom Formula Explained
09:05 Introduction to DataFrame and Pandas
09:26 Python Describe Data
10:58 Assign Name to DataFrame
11:46 Referencing Headers Shortcut
12:22 Examples of pandas Functionalities
14:04 Create Series Python Object
16:12 Plot a Chart in a Calc Cell
17:45 Pandas Documentation
18:16 Calculation Logic of Python Cells
19:06 Examples from Default Libraries
20:30 Plot Multiple Charts As Single Object
21:32 Importing Libraries & Referencing Named Ranges
On this page of the site you can watch the video online Introducing Python in LibreOffice Calc with a duration of hours minute second in good quality, which was uploaded by the user LibrePythonista 13 September 2024, share the link with friends and acquaintances, this video has already been watched 17,825 times on youtube and it was liked by 308 viewers. Enjoy your viewing!
