Tag: Data

June 24, 2024

Python in Excel Data Outputs in Custom Data Visualizations and Algorithms

By  Other Tutorials  0 Comments

Free Download Python in Excel Data Outputs in Custom Data Visualizations and Algorithms
Released 6/2024
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Advanced | Genre: eLearning | Language: English + srt | Duration: 2h 2m | Size: 284 MB
Excel is a powerful tool for data and business analysis, and Python is one of the world’s most popular and dynamic programming languages. Python in Excel works as a sandbox environment. It enables developers and business users to test small parts of code by creating visuals and running algorithms on existing data. In this course, data analytics and business analysis expert Helen Wall focuses on how Python can expand the existing capabilities of Excel. Explore the process and framework of setting up Python to create DataFrame objects and other outputs in Excel. Dive into ways you can use these outputs and objects in custom data visualizations and algorithms that Excel does not have natively, but which Python can create with code. This course highlights ways you can harness the strengths of both Excel and Python in one interface.

(more…)

June 24, 2024

Fundamentals of Data Transformation with pandas and DuckDB SQL

By  Other Tutorials  0 Comments

Free Download Fundamentals of Data Transformation with pandas and DuckDB SQL
Released 6/2024
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Intermediate | Genre: eLearning | Language: English + srt | Duration: 3h 28m | Size: 560 MB
Fundamentals of Data Transformation will present the most essential concepts and best practices in a clear and concise format that allows students to side-step the noise and complexity. While the course will be wide rather than narrow, it will help the student understand their options for development and make an informed choice about where to drill-down.

(more…)