RandomNumeric / New Layer

Generate a new column filled with random numbers using common statistical distributions. Similar to NumPy's random generators or R's random functions, this operation creates random data for statistical analysis, simulation, or testing. Choose from normal (Gaussian) or uniform distributions, with options for reproducible (fixed seed) or truly random generation.

Table
0
0
Table
Float64
Float64 ~

64-bit double-precision floating point value (IEEE 754). Provides about 15-17 decimal digits of precision. Standard choice for scientific and financial calculations.

Float32 ~

32-bit single-precision floating point value (IEEE 754). Provides about 6-8 decimal digits of precision. Good balance of precision and memory efficiency.

StandardNormal

Generate random numbers following the standard normal distribution (also known as Z-distribution or bell curve). This is the most commonly used probability distribution in statistics and machine learning.

Mathematical form: Key properties:

  • Center (mean) at zero
  • Spread (standard deviation) of 1
  • About 68% of values fall between -1 and +1
  • About 95% of values fall between -2 and +2
  • About 99.7% of values fall between -3 and +3

Common uses: baseline random data, statistical testing, noise generation in ML.

Generate random numbers following a normal distribution (Gaussian distribution or bell curve) with customizable center and spread. This is useful for simulating natural phenomena, measurement errors, or any quantities that cluster around a central value. Mathematical form: Where:

  • Mean () sets the center point
  • StdDev () controls the spread

Similar to: np.random.normal(), rnorm() in R

Mean

f64
0

The center point (Mean, ) where values are most likely to occur. In real-world examples, this could be: average height, typical temperature, expected measurement, etc.

1

The spread or variability (StdDev, ) around the center. Larger values create more scattered results. Must be positive. Examples: measurement uncertainty, natural variation in data, tolerance ranges.

Generate random numbers that are equally likely within a specified range. Like rolling a fair die or sampling from a range with no bias. Useful for simulations, random sampling, and generating test data. Mathematical form: Where Low () and High () set the range. Similar to: np.random.uniform(), runif() in R

Low

f64
-1

The minimum value (Low) in the range. Any generated number will be greater than or equal to this value. Example: minimum possible score, lower temperature limit.

High

f64
1

The maximum value (High) in the range. Any generated number will be less than or equal to this value. Example: maximum possible score, upper temperature limit.

Seed

oneof
Random

Use system-provided randomization. Each execution produces different boolean values. Suitable for security-sensitive applications, cryptographic operations, simulation, and cases where true randomness is required.

Generate reproducible random numbers using a seed value. Like using random.seed() in Python or set.seed() in R. Essential for:

  • Reproducible scientific results
  • Testing and debugging
  • Sharing exact random sequences with others
64

The seed number that controls the random sequence. Using the same seed value will always generate the same sequence of random numbers.

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced with the new column with random values.