How to customise my csv file using python instead of Excel macro

Question

I want to store my python code result in to csv file, but here is my python code i am not show my python result in my csv file I have converted the macro vb file to python... Any advise would be more appreciated, because I am new to this.

*unable to enter full code due to site error. Please find my code

import pandas as pd
import csv
import numpy as np 
from vb2py.vbfunctions import *
from vb2py.vbdebug import *

def My_custom_MACRO():
#
# My_custom_MACRO Macro
#
#
Range('A1:A2').Select()
Range('A2').Activate()
Columns('A:A').EntireColumn.AutoFit()
Columns('G:G').Select()
Selection.Insert(Shift=xlToRight, CopyOrigin=xlFormatFromLeftOrAbove)
Columns('P:P').EntireColumn.AutoFit()
Columns('P:P').Select()
Selection.Cut(Destination=Columns('G:G'))
Range('G53').Select()
ActiveWindow.SmallScroll(Down=- 45)
Range('G1').Select()
ActiveCell.FormulaR1C1 = 'Live Deli'
ActiveWindow.SmallScroll(Down=- 9)
ActiveSheet.Range('$A$1:$N$201').AutoFilter(Field=7, Criteria1='>50', Operator=xlAnd)
ActiveSheet.Range('$A$1:$N$201').AutoFilter(Field=4, Criteria1='>50', Operator=xlAnd)
ActiveSheet.Range('$A$1:$N$201').AutoFilter(Field=7, Criteria1='>50', Operator=xlAnd)
ActiveWindow.SmallScroll(Down=0)
ActiveSheet.Range('$A$1:$N$201').AutoFilter(Field=4, Criteria1='>50%', Operator=xlAnd)

df_1=pd.read_csv(r'D:\proj\project.csv',My_custom_MACRO)
df_1.to_csv(r'D:\proj\project_output.csv')

Maybe this can help you: stackoverflow.com/questions/3345336/… — QuagTeX
– QuagTeX, Commented Jul 27, 2021 at 12:30
Is this generated with vb2py? As far as I know this tool works for visual basic and not for vba. Providing the original VBA code would be helpful. The VBA script was recorded and therefore has many unneeded steps. It insert a column at position 7 and names it "Live Deli". A filter greater than 50 or 0.5 is set to column 4 and 7. Because column 7 is empty, there is no data displayed. — Samuel
– Samuel, Commented Jul 27, 2021 at 20:39
yes, code is generated with vb2py. All I need is customise excel without using macro on any pc. pls don't mind the macro code.. I just need align and sort - save as new csv file/ sheet. — Amal Joseph
– Amal Joseph, Commented Jul 28, 2021 at 7:47

CDP1802 · Accepted Answer · 2021-07-30 20:44:00Z

0

I don't see sort in your macro just a column move and filter. Try this ;

import pandas as pd
 
df = pd.read_csv(r'c:\temp\project.csv')
cols = df.columns
# cut column P paste column G as Live Deli
colP = df.pop(cols[14])
df.insert(14,'','')
df.insert(6,'Live Deli',colP)
# apply filter to col 4 and 7
df1 = df.loc[ (df[cols[3]] > 0.5) & (df['Live Deli'] > 50) ] 
# save
df1.to_csv(r'c:\temp\project_output.csv', index=False)

answered Jul 30, 2021 at 20:44

CDP1802

17.3k2 gold badges10 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to customise my csv file using python instead of Excel macro

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related