Python Automation for Remote Workers Series | Working with Files

Показать описание

Let's do this! Let me know if there's specific repetitive tasks that you perform with your remote/office work. In this one we're taking a look at the building blocks of how to use python for file management on your system.

#python #Automation #tutorial

Support the Channel on Patreon --
Join The Socials --
*****************************************************************

Thanks so much for the continued support. This time last year I was thanking you all for hitting 100 subscribers. Now, we just broke 35k. How crazy. Thank you all so much for the continued love and support of my channel. We've come a long way!

Full code from the video:

import os
from datetime import date
import pandas as pd

data_location = 'Docs/Employee Receipts/'
file_list = []

data = {'file_names' : file_list }
file_df = pd.DataFrame(data)
new_file_directory = 'Docs/Processed Receipts/'

string_to_find = 'Derrick'
directory_to_search = 'Docs/Processed Receipts/'
derrick_docs = []
with open(directory_to_search + file) as f:

print(derrick_docs)

Packages (& Versions) used in this video:
os
pandas 1.0.5
datetime

*****************************************************************
Code from this tutorial and all my others can be found on my GitHub:

Check out my website:

If you liked the video - please hit the like button. It means more than you know. Thanks for watching and thank you for all your support!!

--- Channel FAQ --

What text editor do you use?

What Equipment do you use to film videos?

What editing software do you use?
Premiere Pro for video editing
Photoshop for images
After Effects for animations

Do I have any courses available?
Yes & always working on more!

Where do I get my music?
I get all my music from the copyright free Youtube audio library

Let me know if there's anything else you want answered!

-------------------------

Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!

Рекомендации по теме

Комментарии

My favorite part is how you talk through each part of code while you type...absolutely priceless.

capitankak

I think you're the best Python channel around here! Straight to the point. Amazing work, man. Thanks!

luisribeiro

Hey Derrick - from a 40 year old SQL programmer who also loves python your tutorials are priceless. I’ve used Visual Studio a good amount (all my work is in SQL Server) but your simplification of .py files always has me looking for better ways to automate. Much love and God Bless you’re helping your followers tremendously.

capitankak

Thanks again Derrick you are a very talented teacher and it seems you are blessed with a strong intellect, so strong you inspire with me confidence that the problems you deal with have an easy solution. That in itself is a gift you give through your tutorials. Thanks again I guess you must be busy with other things(1 year since you did a video) -whoever employed you is very lucky to have you. All the best

sacredinclinations

This right here is what I need in my life right now. I'm a "data analyst" transitioning to System Improvements and deal with an Access Database and a lot of various data and need to find ways to make my life easier. Thanks for this Tutorial.

ctackett

You do a great job explaining python/how it applies to functional applications in the work place! Great job!

johngrimsley

Love your channel, straight forward without any bullshit. You really deserve more subs !

KaidenXIII

Best python tutor thanks so much... What i like about this guy so much is also his Character he friendly informs you about what he will teach you and then starts immediately without making circus

orkhanahmadov

I have a friend who is automating some work and your videos we're perfect to help. One thing that also helped me get them started was Thonny the ide. For beginners it makes getting python super easy to setup and add packages. Anyway thank you and I hope you keep making more Pandas videos. One function that might warrant a video is merge to mimic vlookup in excel but that can be used on large files. Also if you make that video a discussion on left right and inner joins could help a lot of people. One annoying problem that came up was pandas adding a decimal to things like customer numbers. Thanks again and stay well.

robertpearson

Good to see you're back. Great content as always.
One other trick I also use in similar cases is to add some 'salt' to file_name using uuid. It is useful if you're collecting files from multiple folders, which may include files with the same name. With adding salt into the name, we can prevent the files to over write existing files with the same name.

rushas

Wonderful, keep em coming! I’d love to see a basic server setup in python. I’m a relatively new javascript dev, but the more i watch the more I love python. 👍🏽👍🏽👍🏽

abeechr

Derrick-san we were worried u were gone thanks for all the awesome vids keep it up

beaR.agadaemoN

Great video am working on a windows machine and I did have to change one thing to get it to work:

>>> Had to add that encoding line or else it could not ready my text file:
with open(directory_to_search + file, encoding="Latin-1") as f:

That seemed to do the trick.

shawnbumgarner