sir
I possess a CSV file containing five columns: id, item, address, price, and qty. While it imports correctly into a DataFrame, I wish to calculate a new column, totalamount, which is derived from the product of price and qty. I would appreciate guidance on how to add this new column to the DataFrame during the loading process.
That is covered in the pandas documentation.
https://pandas.pydata.org/docs/user_guide/dsintro.html#column-selection-addition-deletion
1 Like