DataFrame in Expression Language - Revision history

Ollvihe: /* DataFrame sources */

2025-05-23T21:16:58Z

DataFrame sources

← Older revision		Revision as of 21:16, 23 May 2025
Line 820:		Line 820:
	! '''Description'''		! '''Description'''
	\|-		\|-
	\|\|CsvToDataFrame (DataFrame)		\|\|<span id="CsvToDataFrame">CsvToDataFrame</span> (DataFrame)
	\|\|		\|\|
	# CSV data (String)		# CSV data (String)

Ollvihe: /* DataFrame sources */

2025-05-19T17:11:11Z

DataFrame sources

← Older revision		Revision as of 17:11, 19 May 2025
Line 833:		Line 833:
	#** '''DataType''' (String): Data type of the column as one of following: '''String''', '''Boolean''', '''Integer''', '''Float''', '''Date'''. If not specified, the DataFrame will use string data type (i.e., no conversion is made).		#** '''DataType''' (String): Data type of the column as one of following: '''String''', '''Boolean''', '''Integer''', '''Float''', '''Date'''. If not specified, the DataFrame will use string data type (i.e., no conversion is made).
	#* '''Delimiter''' (String): Column delimiter to use. If not specified, semicolon (;) is assumed.		#* '''Delimiter''' (String): Column delimiter to use. If not specified, semicolon (;) is assumed.
	#* '''TimeFormat''' (String): Time format to convert strings into dates. If not specified, date format is automatically detected among the ISO 8601 and RFC 1123 timestamp formats. In addition to this setting, the data type needs to be ''Date'' defined in the ''Columns'' configuration. To ensure robust behavior, it's recommended to specify the time format to avoid incorrect auto-detection. Example time formats: yyyy-MM-dd HH:mm:ss.fffzzz, ddd, dd MMM yyyy HH:mm:ss, M/d/yyyy HH:mm:ss.		#* '''TimeFormat''' (String): Time format to convert strings into dates. If not specified, date format is automatically detected among the ISO 8601 and RFC 1123 timestamp formats. In addition to this setting, the data type needs to be ''Date'' defined in the ''Columns'' configuration. To ensure robust behavior, it's recommended to specify the time format to avoid incorrect auto-detection. Example time formats: "yyyy-MM-dd HH:mm:ss.fffzzz", "ddd, dd MMM yyyy HH:mm:ss", "M/d/yyyy HH:mm:ss".
	#* '''Qualifier''' (String): Qualifier character to use (strings are enclosed to the qualifier characters). If not specified, quotation mark (") is used.		#* '''Qualifier''' (String): Qualifier character to use (strings are enclosed to the qualifier characters). If not specified, quotation mark (") is used.
	#* '''HeaderIncluded''' (Boolean): Whether the first line contains column headers. If this setting is ''true'' and the Columns configuration is defined, the values read from columns override the values in the header row.		#* '''HeaderIncluded''' (Boolean): Whether the first line contains column headers. If this setting is ''true'' and the Columns configuration is defined, the values read from columns override the values in the header row.

Ollvihe: /* DataFrame sources */

2025-05-19T17:10:04Z

DataFrame sources

← Older revision		Revision as of 17:10, 19 May 2025
Line 837:		Line 837:
	#* '''HeaderIncluded''' (Boolean): Whether the first line contains column headers. If this setting is ''true'' and the Columns configuration is defined, the values read from columns override the values in the header row.		#* '''HeaderIncluded''' (Boolean): Whether the first line contains column headers. If this setting is ''true'' and the Columns configuration is defined, the values read from columns override the values in the header row.

	Example without additional configuration:		Example (without additional configuration):
	<pre>		<pre>
	CsvToDataFrame("Column 1;Column 2;Column 3\nA;B;C\nD;E;F")		CsvToDataFrame("Column 1;Column 2;Column 3\nA;B;C\nD;E;F")
	</pre>		</pre>

	Example with additional configuration:		Example (with additional configuration):
	<pre>		<pre>
	CsvToDataFrame(		CsvToDataFrame(

Ollvihe: /* DataFrame sources */

2025-05-19T17:09:41Z

DataFrame sources

← Older revision		Revision as of 17:09, 19 May 2025
Line 833:		Line 833:
	#** '''DataType''' (String): Data type of the column as one of following: '''String''', '''Boolean''', '''Integer''', '''Float''', '''Date'''. If not specified, the DataFrame will use string data type (i.e., no conversion is made).		#** '''DataType''' (String): Data type of the column as one of following: '''String''', '''Boolean''', '''Integer''', '''Float''', '''Date'''. If not specified, the DataFrame will use string data type (i.e., no conversion is made).
	#* '''Delimiter''' (String): Column delimiter to use. If not specified, semicolon (;) is assumed.		#* '''Delimiter''' (String): Column delimiter to use. If not specified, semicolon (;) is assumed.
	#* '''TimeFormat''' (String): Time format to convert strings into dates. If not specified, date format is automatically detected among the ISO 8601 and RFC 1123 timestamp formats. To ensure robust behavior, it's recommended to specify the time format to avoid incorrect auto-detection. Example time formats: yyyy-MM-dd HH:mm:ss.fffzzz, ddd, dd MMM yyyy HH:mm:ss, M/d/yyyy HH:mm:ss.		#* '''TimeFormat''' (String): Time format to convert strings into dates. If not specified, date format is automatically detected among the ISO 8601 and RFC 1123 timestamp formats. In addition to this setting, the data type needs to be ''Date'' defined in the ''Columns'' configuration. To ensure robust behavior, it's recommended to specify the time format to avoid incorrect auto-detection. Example time formats: yyyy-MM-dd HH:mm:ss.fffzzz, ddd, dd MMM yyyy HH:mm:ss, M/d/yyyy HH:mm:ss.
	#* '''Qualifier''' (String): Qualifier character to use (strings are enclosed to the qualifier characters). If not specified, quotation mark (") is used.		#* '''Qualifier''' (String): Qualifier character to use (strings are enclosed to the qualifier characters). If not specified, quotation mark (") is used.
	#* '''HeaderIncluded''' (Boolean): Whether the first line contains column headers. If this setting is ''true'' and the Columns configuration is defined, the values read from columns override the values in the header row.		#* '''HeaderIncluded''' (Boolean): Whether the first line contains column headers. If this setting is ''true'' and the Columns configuration is defined, the values read from columns override the values in the header row.

Ollvihe: /* DataFrame sources */

2025-05-19T17:08:42Z

DataFrame sources

← Older revision		Revision as of 17:08, 19 May 2025
Line 832:		Line 832:
	#** '''Name''' (String): Column name.		#** '''Name''' (String): Column name.
	#** '''DataType''' (String): Data type of the column as one of following: '''String''', '''Boolean''', '''Integer''', '''Float''', '''Date'''. If not specified, the DataFrame will use string data type (i.e., no conversion is made).		#** '''DataType''' (String): Data type of the column as one of following: '''String''', '''Boolean''', '''Integer''', '''Float''', '''Date'''. If not specified, the DataFrame will use string data type (i.e., no conversion is made).
	~~#* '''Qualifier''' (String): Qualifier character to use (strings are enclosed to the qualifier characters). If not specified, quotation mark (") is used.~~
	#* '''Delimiter''' (String): Column delimiter to use. If not specified, semicolon (;) is assumed.		#* '''Delimiter''' (String): Column delimiter to use. If not specified, semicolon (;) is assumed.
	#* '''TimeFormat''' (String): Time format to convert strings into dates. If not specified, date format is automatically detected among the ISO 8601 and RFC 1123 timestamp formats. To ensure robust behavior, it's recommended to specify the time format to avoid incorrect auto-detection. Example time formats: yyyy-MM-dd HH:mm:ss.fffzzz, ddd, dd MMM yyyy HH:mm:ss, M/d/yyyy HH:mm:ss.		#* '''TimeFormat''' (String): Time format to convert strings into dates. If not specified, date format is automatically detected among the ISO 8601 and RFC 1123 timestamp formats. To ensure robust behavior, it's recommended to specify the time format to avoid incorrect auto-detection. Example time formats: yyyy-MM-dd HH:mm:ss.fffzzz, ddd, dd MMM yyyy HH:mm:ss, M/d/yyyy HH:mm:ss.
			#* '''Qualifier''' (String): Qualifier character to use (strings are enclosed to the qualifier characters). If not specified, quotation mark (") is used.
	#* '''HeaderIncluded''' (Boolean): Whether the first line contains column headers. If this setting is ''true'' and the Columns configuration is defined, the values read from columns override the values in the header row.		#* '''HeaderIncluded''' (Boolean): Whether the first line contains column headers. If this setting is ''true'' and the Columns configuration is defined, the values read from columns override the values in the header row.

Ollvihe: /* DataFrame sources */

2025-05-19T17:07:25Z

DataFrame sources

← Older revision		Revision as of 17:07, 19 May 2025
Line 824:		Line 824:
	# CSV data (String)		# CSV data (String)
	# Parameters (Dictionary)		# Parameters (Dictionary)
	\|\|Creates a DataFrame from a CSV data in a string. The ''Columns'' ~~with correct~~ data types need to be specified for the data to be converted into correct types. Otherwise, data will be ~~string~~ in DataFrame.		\|\|Creates a DataFrame from a CSV data in a string. The ''Columns'' configuration containing data types need to be specified for the data to be converted into correct types. Otherwise, data will be stored as strings in the DataFrame.

	Parameters:		Parameters:
Line 834:		Line 834:
	#* '''Qualifier''' (String): Qualifier character to use (strings are enclosed to the qualifier characters). If not specified, quotation mark (") is used.		#* '''Qualifier''' (String): Qualifier character to use (strings are enclosed to the qualifier characters). If not specified, quotation mark (") is used.
	#* '''Delimiter''' (String): Column delimiter to use. If not specified, semicolon (;) is assumed.		#* '''Delimiter''' (String): Column delimiter to use. If not specified, semicolon (;) is assumed.
	#* '''TimeFormat''' (String): Time format to ~~use. use~~. If not specified, ~~following~~ is ~~assumed~~: yyyy-MM-~~ddTHH~~:mm:ss.~~fff~~.		#* '''TimeFormat''' (String): Time format to convert strings into dates. If not specified, date format is automatically detected among the ISO 8601 and RFC 1123 timestamp formats. To ensure robust behavior, it's recommended to specify the time format to avoid incorrect auto-detection. Example time formats: yyyy-MM-dd HH:mm:ss.fffzzz, ddd, dd MMM yyyy HH:mm:ss, M/d/yyyy HH:mm:ss.
	#* '''HeaderIncluded''' (Boolean): ~~Does~~ the first line ~~of the CSV contain~~ column headers. If this ~~configuration value~~ is ''true'' ~~when~~ the Columns configuration is defined, the values read from columns override the values in the header row.		#* '''HeaderIncluded''' (Boolean): Whether the first line contains column headers. If this setting is ''true'' and the Columns configuration is defined, the values read from columns override the values in the header row.

	Example without additional configuration:		Example without additional configuration:

Ollvihe: /* DataFrame sources */

2025-05-15T13:23:14Z

DataFrame sources

← Older revision		Revision as of 13:23, 15 May 2025
Line 824:		Line 824:
	# CSV data (String)		# CSV data (String)
	# Parameters (Dictionary)		# Parameters (Dictionary)
	\|\|Creates a DataFrame from a CSV data in a string. Parameters:		\|\|Creates a DataFrame from a CSV data in a string. The ''Columns'' with correct data types need to be specified for the data to be converted into correct types. Otherwise, data will be string in DataFrame.

			Parameters:
	# '''CSV data''' (String): CSV data to be converted into a DataFrame.		# '''CSV data''' (String): CSV data to be converted into a DataFrame.
	# '''Configuration''' (Dictionary): Dictionary supporting following keys:		# '''Configuration''' (Dictionary): Dictionary supporting following keys:
	#* '''Columns''' (Dictionary*): Array of dictionaries, each defining one column. Following keys are supported:		#* '''Columns''' (Dictionary*): Array of dictionaries, each defining one column. Following keys are supported:
	#** '''Name''' (String): Column name.		#** '''Name''' (String): Column name.
	#** '''DataType''' (String): Data type of the column as one of following: '''String''', '''Boolean''', '''Integer''', '''Float''', '''Date'''.		#** '''DataType''' (String): Data type of the column as one of following: '''String''', '''Boolean''', '''Integer''', '''Float''', '''Date'''. If not specified, the DataFrame will use string data type (i.e., no conversion is made).
	#* '''Qualifier''' (String): Qualifier character to use (strings are enclosed to the qualifier characters). If not specified, quotation mark (") is used.		#* '''Qualifier''' (String): Qualifier character to use (strings are enclosed to the qualifier characters). If not specified, quotation mark (") is used.
	#* '''Delimiter''' (String): Column delimiter to use. If not specified, semicolon (;) is assumed.		#* '''Delimiter''' (String): Column delimiter to use. If not specified, semicolon (;) is assumed.
	#* '''TimeFormat''' (String): Time format to use. use. If not specified, following is assumed: yyyy-MM-ddTHH:mm:ss.fff.		#* '''TimeFormat''' (String): Time format to use. use. If not specified, following is assumed: yyyy-MM-ddTHH:mm:ss.fff.
	#* '''HeaderIncluded''' (Boolean): Does the first line of the CSV contain column headers. If this configuration value is ''true'' when the Columns configuration is defined, the values read from columns override the values in the header row.		#* '''HeaderIncluded''' (Boolean): Does the first line of the CSV contain column headers. If this configuration value is ''true'' when the Columns configuration is defined, the values read from columns override the values in the header row.

	The types of cell values are as follows: If columns-parameter has been specified with column data types, a conversion is made to convert all the column values to this data type. Otherwise, all values are stored as strings.

	Example without additional configuration:		Example without additional configuration:
	<pre>		<pre>
	CsvToDataFrame(`Column 1;Column 2;Column 3\nA;B;C\nD;E;F`)		CsvToDataFrame("Column 1;Column 2;Column 3\nA;B;C\nD;E;F")
	</pre>		</pre>

Line 845:		Line 845:
	<pre>		<pre>
	CsvToDataFrame(		CsvToDataFrame(
	"A,B,C~~\nD~~,E,F",		`A,B,C
			D,E,F`,
	#{		#{
	"Delimiter": ",",		"Delimiter": ",",

Ollvihe: /* DataFrame sources */

2025-05-15T13:19:06Z

DataFrame sources

← Older revision		Revision as of 13:19, 15 May 2025
Line 825:		Line 825:
	# Parameters (Dictionary)		# Parameters (Dictionary)
	\|\|Creates a DataFrame from a CSV data in a string. Parameters:		\|\|Creates a DataFrame from a CSV data in a string. Parameters:
	# '''CSV data''' (String): ~~String containing~~ CSV data to be converted into a DataFrame.		# '''CSV data''' (String): CSV data to be converted into a DataFrame.
	# '''Configuration''' (Dictionary): Dictionary supporting following keys:		# '''Configuration''' (Dictionary): Dictionary supporting following keys:
	#* '''Columns''' (Dictionary*): Array of dictionaries, each defining one column. Following keys are supported:		#* '''Columns''' (Dictionary*): Array of dictionaries, each defining one column. Following keys are supported:

Ollvihe: /* DataFrame sources */

2025-05-15T13:18:43Z

DataFrame sources

← Older revision		Revision as of 13:18, 15 May 2025
Line 822:		Line 822:
	\|\|CsvToDataFrame (DataFrame)		\|\|CsvToDataFrame (DataFrame)
	\|\|		\|\|
	# CSV data		# CSV data (String)
	# Parameters		# Parameters (Dictionary)
	\|\|Creates a DataFrame from a CSV data in a string. Parameters:		\|\|Creates a DataFrame from a CSV data in a string. Parameters:
	# '''CSV data''' (String): String containing CSV data to be converted into a DataFrame.		# '''CSV data''' (String): String containing CSV data to be converted into a DataFrame.

Ollvihe: /* DataFrame sources */

2025-05-15T13:18:14Z

DataFrame sources

← Older revision		Revision as of 13:18, 15 May 2025
Line 824:		Line 824:
	# CSV data		# CSV data
	# Parameters		# Parameters
	\|\|Creates a DataFrame from a CSV string. Parameters:		\|\|Creates a DataFrame from a CSV data in a string. Parameters:
	# '''CSV ~~string~~''': String containing CSV data to be converted into a DataFrame.		# '''CSV data''' (String): String containing CSV data to be converted into a DataFrame.
	# '''Configuration''': Dictionary supporting following keys:		# '''Configuration''' (Dictionary): Dictionary supporting following keys:
	#* '''Columns''': Array of dictionaries, ~~supporting following~~ keys:		#* '''Columns''' (Dictionary*): Array of dictionaries, each defining one column. Following keys are supported:
	#** '''Name''': Column name.		#** '''Name''' (String): Column name.
	#** '''DataType''': Data type of the column as one of following: '''String''', '''Boolean''', '''Integer''', '''Float''', '''Date'''.		#** '''DataType''' (String): Data type of the column as one of following: '''String''', '''Boolean''', '''Integer''', '''Float''', '''Date'''.
	#* '''Qualifier''': Qualifier character to use~~, which is~~ enclosed. ~~The default is double-quote~~ (").		#* '''Qualifier''' (String): Qualifier character to use (strings are enclosed to the qualifier characters). If not specified, quotation mark (") is used.
	#* '''Delimiter''': ~~Row~~ delimiter to use. If not specified, semicolon (;) is assumed.		#* '''Delimiter''' (String): Column delimiter to use. If not specified, semicolon (;) is assumed.
	#* '''TimeFormat''': Time format to use. ~~Default~~: yyyy-MM-~~dd HH\\~~:mm\\:ss,fff		#* '''TimeFormat''' (String): Time format to use. use. If not specified, following is assumed: yyyy-MM-ddTHH:mm:ss.fff.
	#* '''HeaderIncluded''': Does the first line of the CSV contain column headers. If this configuration value is ''true'' when the Columns configuration is defined, the values read from columns override the values in the header row.		#* '''HeaderIncluded''' (Boolean): Does the first line of the CSV contain column headers. If this configuration value is ''true'' when the Columns configuration is defined, the values read from columns override the values in the header row.

	The types of cell values are as follows: If columns-parameter has been specified with column data types, a conversion is made to convert all the column values to this data type. Otherwise, all values are stored as strings.		The types of cell values are as follows: If columns-parameter has been specified with column data types, a conversion is made to convert all the column values to this data type. Otherwise, all values are stored as strings.

	Example:		Example without additional configuration:
	<pre>		<pre>
	CsvToDataFrame(`Column 1;Column 2;Column 3\nA;B;C\nD;E;F`)		CsvToDataFrame(`Column 1;Column 2;Column 3\nA;B;C\nD;E;F`)
			</pre>

			Example with additional configuration:
			<pre>
			CsvToDataFrame(
			"A,B,C\nD,E,F",
			#{
			"Delimiter": ",",
			"HeaderIncluded": false
			}
			)
	</pre>		</pre>
	\|-		\|-