cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
View Original Published Thread

Data Automation with Python and JMP 18: A Powerful Synergy

In my previous post , I showed how Python integration in JMP could be used to scrape YouTube video transcripts for analysis in JMP. That post also introduced a challenge that many people working with data face: the importance of finding more efficient methods for saving and restructuring data, rather than simply copying and pasting.

Today, I want to share an exciting update: a Python script that allows you to save YouTube video transcripts directly into a JMP data table. This integration not only saves time, but also improves accuracy and efficiency in data management.

The Power of JMP 18

JMP 18 has introduced several new features that make data analysis more efficient and user-friendly. Some of the highlights include:

Platform Presets

Users can save their preferred settings for future use, making repetitive tasks faster. Settings are shareable, making standardizing reports, styles, and colors easier than ever.

undefined

Improvements to the Prediction Profiler

Enhanced interactive model exploration capabilities.

undefined

Integrating Python with JMP

My colleague @yasmine_hajar has developed a Python script that uses the YouTube Transcript API to get video transcripts and save them directly to a JMP data table. Here is the script:

undefined

How the Script Works

  1. Fetching Transcripts : The script uses the YouTube Transcripts API to get the transcripts for the specified video in Spanish.
  2. Creating the Data Table in JMP : A new data table is created in JMP called “Spanish Transcripts” with columns for the text, start, and duration of each segment of the transcript.
  3. Populating the Data Table : The script goes through each segment of the transcript and populates the corresponding columns in the JMP data table.

undefined

Benefits of this integration

  • Efficiency : Automate the process of obtaining and storing transcripts, saving time and reducing errors.
  • Accuracy : By eliminating the need for manual copy and paste, data accuracy is improved.
  • Ease of Use : JMP 18 and Python work together seamlessly, allowing users to take advantage of the best of both worlds.

Conclusion

JMP 18's integration with Python opens up a world of possibilities for data management. This script is just one example of how we can use these tools to improve our efficiency.

To get started with JMP integration with Python, see this beginner's guide: Getting started with Python integration in JMP® 18 - JMP User Community

This post originally written in Spanish and has been translated for your convenience. When you reply, it will also be translated back to Spanish.