I've got a data frame df1 with multiple columns and rows. Simple example:
TIME T1 T2
1 10 100
2 20 200
3 30 300
I'd like to create an empty data frame df2 and later on, add new columns with the calculation results.
For this moment my code looks like this:
df1=pd.read_csv("1.txt",index_col="TIME")
df2=df1.copy()[[]] #copy df1 and erase all columns
...adding two new columns:
df2["results1"],df2["results2"]=df1["T1"]*df["T2"]*3,df1["T2"]+100
Is there any better/safer/faster way to do this ? Is it possible to create an empty data frame df2 and only copy index from df1 ?