The know-how of pandas, such as avoiding loops and apply, is also useful for FireDucks. Here are some tips to improve performance in FireDucks. Avoid loops Looping out data from a DataFrame is slow, so it is better to use the DataFrame API as much as possible (this is also true for pandas). For example, the following loop processes the elements of a Series one by one. s =0for i in range(len(df)): if df["A"][i] >2: s += df["B"][i] Using the API, you can write the following. s = df[df["A"] >2][...
