Creating Excel File From Bash Script output with python

Question

I have an output file which created from a bash script.

that output file is:

   xyz|xxx.local|Protocol 2|Root Acces Denied
   xyz|xxx1.local|Protocol 2|Root Acces Denied

I am trying to create Excel file from this which is going to be

 Column1  Column2     Column3       Column4
  xyz    xxx.local   Protocol 2  Root Acces Denied
  xyz    xxx.local   Protocol 2  Root Acces Denied

How can I do this with Python?

Welcome to SO. Stack Overflow is a question and answer site for professional and enthusiast programmers. The goal is that you add some code of your own to your question to show at least the research effort you made to solve this yourself. — Cyrus
– Cyrus, Commented Sep 6, 2018 at 11:00

gehbiszumeis · Accepted Answer · 2018-09-06 11:33:46Z

1

You can do that pretty very elegantly with pandas Dataframes. Check pandas.read_csv and pandas.DataFrame.to_excel.

If you are new to Python and you haven't worked with pandas so far, I recommend you to look up Python/xls questions here in stackoverflow (e.g. here) and try those, before jumping on pandas.

Anyway, if you need a quick solution copy & paste this

import pandas as pd

# Load your bash output file in pandas dataframe
df = pd.read_csv('bash_outfile.out', sep='|', names=['Column1', 'Column2',
                                                     'Column3', 'Column4'])

# Open pandas ExcelWriter and write to *.xls file
with pd.ExcelWriter('my_xls.xls') as writer:
    df.to_excel(writer)

which will do what you want.

answered Sep 6, 2018 at 11:33

gehbiszumeis

3,7495 gold badges28 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Creating Excel File From Bash Script output with python

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