Excel/Mathematica Extracting Data with a twist

  • Context: Mathematica 
  • Thread starter Thread starter fujiheero
  • Start date Start date
  • Tags Tags
    Data
Click For Summary
SUMMARY

The discussion focuses on extracting specific data points from an Excel matrix into Mathematica for analysis. The user successfully imports 2500 data points using the Import function but seeks a method to extract every nth point, specifically every 50th or 100th point. The solution provided involves using the syntax expr[[m;;n;;s]] in Mathematica to select every s'th element from the data set. This approach allows for efficient data manipulation and visualization in Mathematica.

PREREQUISITES
  • Familiarity with Excel data structures and functions
  • Understanding of Mathematica's Import function
  • Basic knowledge of Mathematica syntax and indexing
  • Experience with data visualization techniques in Mathematica
NEXT STEPS
  • Research the Mathematica Import function in detail
  • Learn about advanced indexing techniques in Mathematica
  • Explore data visualization options in Mathematica
  • Investigate Excel's data manipulation functions for better integration
USEFUL FOR

This discussion is beneficial for data analysts, Mathematica users, and Excel users looking to optimize data extraction and visualization processes.

fujiheero
Messages
2
Reaction score
0
I am trying to extract data to mathematica from Excel. I understand the Import function and i can get all my 2500 Points into Mathematica however, I only need to analyze every 100th or every 50th point to plot on my graph in mathematica. My question is:

Is there a way to extract data within a matrix but only extract every nth cell? (in either mathematica or excel).

Thanks in advance.
 
Physics news on Phys.org
Thank you!
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 9 ·
Replies
9
Views
3K
  • · Replies 5 ·
Replies
5
Views
4K
  • · Replies 5 ·
Replies
5
Views
3K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 18 ·
Replies
18
Views
5K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 1 ·
Replies
1
Views
3K