Seed data from Excel to SQL insert query with minimal effort — If you have always tried to manually seed your data from excel to SQL insert query database then you would love this Python script more than anything. Imagine you had to seed 100 plus records it would take around 30 minutes depending on your speed and accuracy. All this can…

№8 will make you a pro python programmer — If you use Python every day and want to learn a few tricks that will make your code more readable then you can check out these 18 snippets below. 1. Interpolated format strings F-strings solve the biggest problems with C-style format strings and are powerful because they allow for arbitrary Python expressions to be…

These are life hacks! — 1. Homework Automation Script This script doesn’t complete your homework but is somewhat close enough. It is a google search for you mentioned in the docx file. from docx import Document from googlesearch import search filename = "PythonQuestions.docx" questions = [] def getText(filename): doc = Document(filename) fullText = []…

Use them and let people wonder — Today I’ll share a few snippets with you from the book Python Tricks: The Book. This book has a lot of in-depth information about a few snippets we use daily and help you understand how they work. I’d recommend you have a look for yourself after reading this article. 1. Use __repr__ & __str__ methods for better representation of a class object >>>…

Understand Python functions in-depth somewhat — Functions are objects Everything in a Python program is represented by objects or relations between objects like strings, lists, modules, and functions are all objects. This means a function can be assigned to a variable, just like any object.

A list of guides, books, and GitHub repositories for learning Python. — This article aims to provide little information about the community, books, or GitHub repos which I recommend for learning Python or diving deep into Python language. NOTE: This list doesn’t contain any data science or ML-related stuff. Just Pure Python. Official Python-Dev Guide Python Developer's Guide This guide is a comprehensive resource for contributing to Python - for both new and experienced contributors. It is…devguide.python.org

A must-read article for those who use assert operation for data validation. — If you are constantly using assert operation for data validation, you should stop. Why? Assertions can be turned off by simply adding -0 or -00 on the command line: python filename -O or -OO

A list of Python functions that make life easier. — 1. enumerate(iterable, start=0) This function creates a enumerate object which takes in an iterable sequence. We can use this function often when we need the iterator along with the value unlike >>> range(len(list)) Example: >>> chessPieces = ["Pawns", "Rook", "Horse", "Bishops", "King", "Queen"] >>> list(enumerate(chessPieces)) [(0, 'Pawns'), (1, 'Rook'), (2, 'Horse'), (3, 'Bishops'), (4, 'King')…

First of all Congrats on the new beginning, I wish you all the best on your journey. I might not be the best person to provide advice, but I love Python and try to explore more things to develop in Python. I have tried my hands on pretty much all…