import pandas as pd import itertools import csv import os, sys def pricing(filename, n): name = str(n)+'.csv' # copy sample csv as it is writer = open(name, 'w') writer.write(open(filename).read()) writer.close() # create dataframe for new columns and calculate results headers = ['A', 'B] old_df = pd.read_csv(filename) new_df = pd.DataFrame(columns=headers) new_df['A'] = round((old_df['price1']+old_df['price2']+old_df['price3'])/3, 2) new_df['B'] = round(old_df['Volume']+new_df['A'], 2) # append dataframe to existing csv new_df.to_csv(name, index = False, header = True, mode='a')
Run
Reset
Share
Import
Link
Embed
Language▼
English
中文
Python Fiddle
Python Cloud IDE
Follow @python_fiddle
Browser Version Not Supported
Due to Python Fiddle's reliance on advanced JavaScript techniques, older browsers might have problems running it correctly. Please download the latest version of your favourite browser.
Chrome 10+
Firefox 4+
Safari 5+
IE 10+
Let me try anyway!
url:
Go
Python Snippet
Stackoverflow Question