Oct-18-2020, 02:58 PM
I timeit and there is some performance gain, but not as much as I expected
import pandas import timeit raw_data = pandas.DataFrame(columns=["Column_0", "Column_1", "Column_2", "Column_3", "Column_4", "Column_5", "Column_6", "Column_7", "Column_8"]) raw_data.loc[0,:] = (315589, "CHZ3", 1100, 218, 694.63, None, -1.589, 0, 1.3694) raw_data.loc[1,:] = (364048, "CHZ3", 1100, 320, 12.09, None, -7.216, 0, 59.89) print(timeit.timeit("raw_data['Column_5'] = raw_data['Column_3'] * 8950 + raw_data['Column_4']", setup='from __main__ import raw_data', number=20000)) print(timeit.timeit("raw_data.iloc[:,5] = raw_data.iloc[:,3] * 8950 + raw_data.iloc[:,4]", setup='from __main__ import raw_data', number=20000))
Output:9.739402721000033
11.304438857000036
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs