Convert Excel to NumPy

Introduction to NumPy

NumPy (Numerical Python) is an open-source numerical computation extension of Python. This tool can be used to store and process large matrices, which is much more efficient than Python’s nested list structure (which can also be used to represent matrices). It supports a large number of dimensional arrays and matrix operations, and also provides a large number of mathematical function libraries for array operations.

The main functions of NumPy:

  1. Ndarray, a multidimensional array object, is a fast, flexible, and space saving data structure.
  2. Linear algebra operations, including matrix multiplication, transposition, inversion, etc.
  3. Fourier transform, performing a fast Fourier transform on an array.
  4. Fast operation of floating-point arrays.
  5. Integrate C language code into Python to make it run faster.

Using Aspose.Cells for Python via .NET API, you can convert Excel, TSV, CSV, Json and many different formats to Numpy ndarray.

How to Convert Excel Workbook to NumPy ndarray

Here’s an example code snippet to demonstrate how to export excel data to a NumPy array using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Traverse excel data and export data to NumPy ndarray using Aspose.Cells for Python via .NET.

The output result:

[[['City' 'Region' 'Store']    
  ['Chicago' 'Central' '3055'] 
  ['New York' 'East' '3036']   
  ['Detroit' 'Central' '3074']]

 [['City2' 'Region2' 'Store3']
  ['Seattle' 'West' '3000']
  ['philadelph' 'East' '3082']
  ['Detroit' 'Central' '3074']]

 [['City3' 'Region3' 'Store3']
  ['Seattle' 'West' '3166']
  ['New York' 'East' '3090']
  ['Chicago' 'Central' '3055']]]

How to Convert Worksheet to NumPy ndarray

Here’s an example code snippet to demonstrate how to export worksheet data to Numpy ndarray using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Get the first worksheet.
  3. Convert worksheet data to Numpy ndarray using Aspose.Cells for Python Excel library.

The output result:

[['City' 'Region' 'Store']    
 ['Chicago' 'Central' '3055'] 
 ['New York' 'East' '3036']   
 ['Detroit' 'Central' '3074']]

How to Convert a Range of Excel to NumPy ndarray

Here’s an example code snippet to demonstrate how to export range data to NumPy ndarray using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Get the first worksheet.
  3. Create the Range.
  4. Convert Range data to NumPy ndarray using Aspose.Cells for Python Excel library.

The output result:

[['Region' 'Store']
 ['Central' '3055']
 ['East' '3036']]

How to Convert a ListObject of Excel to NumPy ndarray

Here’s an example code snippet to demonstrate how to export ListObject data to NumPy ndarray using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Get the first worksheet.
  3. Create ListObject object.
  4. Convert ListObject data to NumPy ndarray using Aspose.Cells for Python Excel library.

The output result:

[['City' 'Region' 'Store']
 ['Chicago' 'Central' '3055']
 ['New York' 'East' '3036']
 ['Detroit' 'Central' '3074']]

How to Convert a Row of Excel to NumPy ndarray

Here’s an example code snippet to demonstrate how to export Row data to NumPy ndarray using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Get the first worksheet.
  3. Get Row object by row index.
  4. Convert Row data to NumPy ndarray using Aspose.Cells for Python Excel library.

The output result:

['Detroit' 'Central' '3074']

How to Convert a Column of Excel to NumPy ndarray

Here’s an example code snippet to demonstrate how to export Column data to NumPy ndarray using Aspose.Cells for Python via .NET:

  1. Load the sample file.
  2. Get the first worksheet.
  3. Get Column object by column index.
  4. Convert Column data to NumPy ndarray using Aspose.Cells for Python Excel library.

The output result:

['Store' '3055' '3036' '3074']