Search Results

ListOfArrays (LOA) is a simple list where each item is an array of objects, and each array represents a row. As LOA stores tabular data, all rows have the same length. LOA is lightweight and a list...
link: ", True) Log(table.ToString(5)) Log("***** Get cats:") Dim loa As ListOfArrays = table...
link: v0.94 - New ListOfArrays.VerifyRowsLengths method. Ensures that all rows are with the correct length...
link: back to LOA: Dim t As ListOfArrays = LOAUtils.CreateFromListOfMaps(maps, Null) The headers...

:\Users\H\Downloads\Countries of the world.xlsx", "", 0) 'Select a range to be read as a LOA: Dim loa As ListOfArrays = res.GetListOfArrays(xl.CreateXLRange(xl.AddressName("B4"), res... column. Need to clean... Dim ls As LOASet = loa.CreateLOASet Do While ls.NextRow Dim CountryName...) Loop loa.Sort("Population", False) 'print a few columns: Log(loa.ToListOfArrays(Array...(5)) 'get data of single country: Dim Zim As ListOfArrays = loa.GetRowsByValue("Country...

Visualize a LOA with B4XTable: Private Sub ShowLoaInTable(loa As ListOfArrays, table As B4XTable, DateColumns As List) table.Clear If loa.IsEmpty Then Return If loa.FirstRowIsHeader... As Int In loa.ColumnIndices Dim ColType As Int Dim ColName As String = loa.Header(col... ColType = table.COLUMN_TYPE_DATE Else Dim FirstValue As Object = loa.GetValueDefault....SubList(loa.mInternalArray, loa.mFirstDataRowIndex, loa.mInternalArray.Size)) End Sub Usage example...

/android/forum/threads/b4x-loa-listofarrays-lightweight-powerful-and-flexible-collection.170543...

LOAs to DataFrames and vice versa. 'Adds a converter that converts dataframes to a list of arrays (not LOA yet) when a dataframe is fetched. Private Sub AddDataFrameConverter Dim Pandas..., name=None))")) End Sub 'Converts a LOA to DataFrame. Public Sub LOAToDataFrame (LOA As ListOfArrays) As PyWrapper Dim Code As String = $" def LOAToDataFrame (LOA): df = pandas.DataFrame(LOA, columns=LOA) return df "$ Return Py.RunCode("LOAToDataFrame"...

https://www.b4x.com/android/forum/threads/b4x-loa-listofarrays-lightweight-powerful-and-flexible-collection.170543/ https://www.b4x.com/android/forum/threads/b4x-minimalistutils.155724/ Which one is better? My answer: Depends LOA is list of arrays MinimaList is list of maps In LOA, you can convert between List and ListOfArrays. In MinimaList, you cannot convert your List directly at the moment. Each item as type of Maps is added to the internal list. Instead of accessing the item using...

This page https://www.b4x.com/android/forum/threads/b4x-loa-listofarrays-lightweight-powerful-and-flexible-collection.170543/#content has two attachments for download. Both with the same name...
link: I think it deserve to join the b4x object family and be part of b4x language like list map array .....
link: It will be included as an internal library in the near future. I think it deserve to join the b4x ...
link: i wonder why not put it as a build in b4x object and not use a b4xlib for it It will be included a...

Updates: - V2.10 - Adds support for reading to LOA and writing from LOA: https://www.b4x.com/android/forum/threads/xlutils-loa-reading-and-writing-excel-data-with-listofarrays.170983/ Depends.../b4x-loa-listofarrays-lightweight-powerful-and-flexible-collection.170543/#content - V2.09 - New bidi...
link: - V2.10 - Adds support for reading to LOA and writing from LOA: https://www.b4x.com/android/forum...

(replacement of original; appended as extra columns; as a new LOA) Think about the evaluator as an interpreter for single lines of B4X code. For example, if 'wLOA' is instance of wLOAExtras and...
link: data(i) = Array(Rnd(0, 600), Rnd(0, 600)) Next Dim TuplesLOA As ListOfArrays = wLOA.collect(3...
link: dependencies, implement visualization of LOA's including missing and unusual values Anyone who has...
link: -affected. The result has the same number of rows as the original LOA. If the date/time string...

with default column names Dim LOA1 As ListOfArrays = wLOAUtils.randomInt(5, 3, Array(1, 10)) 'Rename columns for demo wLOAUtils.renameColumns(LOA1, CreateMap("c_1"... the table wLOAUtils.display(LOA1, 0, 0) 'Modify the table by computing a new column based on an evaluated expression wLOAUtils.eval(LOA1, "Result", "A + B * C") wLOAUtils.display(LOA1, 0, 0) #if demoLog A B C ―――――――――――――――――――――――― 1...