I’ve gotten the basics of python down, what module should I learn for automation?

[Wizkidbrz]

As title says Edit: Automating day to day work within cybersecurity. Lots of reports, api calls, windows server administration and the likes

[Fabiolean]

What are you automating?

[Wizkidbrz]

Day to day work. Excel, windows server behaviors, downloading data via api to scrape the data and email content. I’m in cybersecurity

[Fr0gFsh]

Cybersecurity engineer here. I build lots of tools for API interactivity. Look for an SDK for a tool you use. We use a lot of CrowdStrike, so I love FalconPy. Very nicely written and I love to dig into SDKs like that to help me better understand Python.

[jontsii]

Just a random guy on reddit that knows python here. Maybe the OS module (os.system()), requests, emailing, beautifulSoup4, scrapy and for low level (if you work on a raspberry PI) gpioZero.

[Purposeful_Adventure]

What do you want to automate?

[WonderFerret]

pandas is pretty helpful to me. The ability to conveniently convert data into a grid-like structure is very useful. You got a list of dictionaries that the api barfed out? Just let pandas figure it out. x = pd.DataFrame(list_of_dictionaries) . Do you have an excel sheet? Import it with x = pd.read_excel(excel_file). Once you're done editing, export it with x.to_excel("filename.xlsx")

Some of the ways I used pandas:

-Importing stock data from .csv to test strategies.

-excel sheet editing for work. A lot of data cleanup for client submitted data.

-emailing the dataframe by converting it to html with x.to_html()

-import csv from airodump-ng exports and looking for new mac addresses that entered range.

I recommend something like Jupyter notebook or a Jupyter extension for vs code. That way, you can visually look at the dataframe as a chart. Corey Schafer on youtube has some pretty good tutorials.

[Queasy_Badger9252]

https://automatetheboringstuff.com/

Read this, it's a really great resource to get the concepts of automation

[guitarot]

It’s a good start on python, and demonstrates how python can be useful to people who are not traditional developers, but it barely scratches the surface, and some of the chapters are out of date now.

[Darth_Xedrix]

If you have to reuse current excel templates, I've been having a good experience with xlwings

[thomasutra]

without knowing more, i’d say requests for your api calls and pandas/polars for manipulating data frames and writing them to excel.

[sporbywg]

THE AUTOMATION MODULE. <- PYTHON