Virajp at 01:26, 17 June 2025

2025-06-17T01:26:36Z

Virajp: Created page with "= Z Functions with CSV and XLSX Files = '''Z Functions''' are specialized computational functions within the ZCubes platform that provide powerful data manipulation an..."

2025-06-16T19:28:41Z

Created page with "= Z Functions with CSV and XLSX Files = '''Z Functions''' are specialized computational functions within the ZCubes platform that provide powerful data manipulation an..."

New page

= Z Functions with CSV and XLSX Files =

'''Z Functions''' are specialized computational functions within the [[Z3|ZCubes]] platform that provide powerful data manipulation and analysis capabilities for structured file formats, particularly CSV (Comma-Separated Values) and XLSX (Excel) files. These functions enable seamless data import, processing, and analysis within ZCubes' multi-language computational environment.

== Overview ==

Z Functions represent a core component of ZCubes' data processing capabilities, designed to handle the most common structured data formats used in business, research, and educational contexts. The integration supports both CSV and XLSX formats with comprehensive functionality for data import, manipulation, transformation, and analysis.

The Z Functions framework provides a unified interface for working with tabular data, regardless of the source format, enabling users to perform complex data operations without switching between different tools or environments.

== Core Z Functions for File Operations ==

=== CSV File Functions ===
[[File:Csv file.png|thumb]]
[[File:Return.png|thumb]]
==== READCSV() ====
The primary function for importing CSV data into ZCubes:

<syntaxhighlight lang="z^3">
csv_data = READCSV("D:/ZAP_Testing/data.csv")
</syntaxhighlight>

'''Parameters:'''
* File path (string): Full path to the CSV file

'''Output Value:''' Structured data object with column and row.

=== XLSX File Functions ===

==== READFILE() ====
Primary function for importing Excel files:

<syntaxhighlight lang="z^3">
xlsx_data = READFILE("D:/ZAP_Testing/data.xlsx")
</syntaxhighlight>

'''Parameters:'''
* File path (string): Full path to the XLSX file
* Sheet specification (optional): Target worksheet name or index
* Range specification (optional): Cell range to import

== Data Manipulation Functions ==

=== Column Operations ===
[[File:P4.png|thumb]]
==== Column Access and Analysis ====
<syntaxhighlight lang="z^3">
// Extract specific columns
salary_column = [csv_data.column(4);]
total_salary = SUM(csv_data.column(4))
PRINT(total_salary);
</syntaxhighlight>

<pre>
770000
</pre>

==== Statistical Functions ====
1)
<syntaxhighlight lang="z^3">
COUNT(actual_ages)
</syntaxhighlight>
Output:
<pre>
11
</pre>
2)
[[File:P5.png|thumb]]
<syntaxhighlight lang="z^3">
AVG(actual_ages)
</syntaxhighlight>
Output:
<pre>
77000
</pre>

== Data Manipulation operations using z^3 function ==

=== Salary Distribution Processing ===
[[File:2.png|thumb]]
<syntaxhighlight lang="z^3">
c_suite_salaries = salary_column#[3,7,9]
mid_management = salary_column#[1,4,6]
entry_level = salary_column#[0,2,5]

salary_distribution = [
["Executive", SUM(c_suite_salaries), AVG(c_suite_salaries)],
["Management", SUM(mid_management), AVG(mid_management)],
["Entry Level", SUM(entry_level), AVG(entry_level)]
]

PRINT(salary_distribution);
</syntaxhighlight>

Output:
<pre>
[["Executive",210000,70000],["Management",230000,76666.66666666667],["Entry Level",SUM(entry_level),AVG(entry_level)]]
</pre>

=== CSV Data Sampling and Performance Analysis ===
[[File:89.png|thumb]]
<syntaxhighlight lang="z^3">
CSV_data =
READCSV("D:/ZAP_Testing/data.csv")

// Creating Salary samples for analysis
sample_indices = 5#[0,2]
sampled_salaries =
salary_column#sample_indices
sampled_names =
csv_data.column(0)#sample_indices

salary_bands = 4#[60000,10000]
performance_tiers = salary_column#[0,4,7,9]
</syntaxhighlight>

Output:
<pre>
[[["salary"],["60000"],["65000"],["72000"]],[],[]]
</pre>

=== Advanced Statistical Operations ===
<syntaxhighlight lang="z^3">
// Filter employees by age criteria
people_below_30 = csv_data|x[1]<30|
actual_ages = people_below_30.column(1)
actual_names = people_below_30.column(0)

// Calculate comprehensive statistics
total_employees = COUNT(csv_data)
average_salary = AVG(salary_column)

PRINT("Total Employees: " + total_employees);
PRINT("Average Salary: " + average_salary);
</syntaxhighlight>

Output:
<pre>
Total Employees: 12
Average Salary: 64166.67
</pre>

== See Also ==

* [[Z3]]
* [[# Operator ]]

@@ Line 10: / Line 10: @@
 == Core Z Functions for File Operations ==
 === CSV File Functions ===
 [[File:Csv file.png|thumb]]
@@ Line 27: / Line 26: @@
 === XLSX File Functions ===
-==== READFILE() ====
+[[File:Xlsx.png|thumb]]
-Primary function for importing Excel files:
+==== Method 2: Using xlsx library ====
-<syntaxhighlight lang="z^3">
+<syntaxhighlight lang="javascript">
-xlsx_data = READFILE("D:/ZAP_Testing/data.xlsx")
+const XLSX = require('xlsx');
 </syntaxhighlight>
 == Data Manipulation Functions ==
@@ Line 141: / Line 192: @@
 </pre>
 == See Also ==
 * [[Z3]]
-* [[# Operator ]]
+* [[# Operator]]

Z functions with CSV and XLSX files - Revision history

Virajp at 01:26, 17 June 2025

Virajp: Created page with "= Z Functions with CSV and XLSX Files = '''Z Functions''' are specialized computational functions within the ZCubes platform that provide powerful data manipulation an..."