Top Rated Python Books on Amazon 2020

1. Python Crash Course: A Hands-on, Project based Introduction To Programming This book is highly recommended by many verified purchasers on Amazon. They mentioned that it is a great book for beginners to learn Python. Below are some of their comments “Effective For Teaching The Basics” “From your first exception error to your first Hello […]

Python: Get last 4 characters of a string [one line code]

Python code to get last four characters of a string. This single line code, excluding string line, prints the last 4 characters of the string. Change the number to get more or less characters. Example string: GetHowStuff Expected Output (last 4 characters): tuff string=”GetHowStuff” #prints last 4 characters of the string print(string[-4:])

Python: Extract file name from URL path [with and without extension]

Python code to extract the file name from path or URL is explained below. Find the delimiter “/” position before the file name using¬† ¬†firstpos=path.rfind(“/”) Find the last position of the file name using lastpos=len(path) Extract the file name using path[firstpos+1:lastpos]. Add 1 to the first position to avoid extracting the delimeter “/”. Python code […]

Excel combine multiple cells into one separated by comma [Quick Way]

combine-random-cells-excel

Excel function to combine multiple cells into one separated by comma. This is the quick way to combine cells separated by any specified delimiter. Use TEXTJOIN() function, which combines the text from multiple cells or ranges separated by the specified delimiter (comma, semi colon or any other). Syntax of TEXTJOIN function TEXTJOIN(delimiter, ignore_empty, text1, [text2], […]

How to get alternate column data from Excel sheet

Add a row as first row and add numbers in columns as 1,2,1,2 etc. Then highlight your entire range of data. Go to Data menu -> select Sort and Options… Change your Orientation to “Sort Left and Right”. Choose row 1 as sort by and Smallest to Largest. Excel will be changed with alternate column […]

How to backup/Restore blogger blog theme? 2019 [With Images]

Below article guides you on how to backup/restore theme/template on blogger blog with images. This is useful for new blogspot bloggers. Backup blogger blog theme Login to your blogger blog account Goto Theme On top-right, you will see Backup / Restore button. Click on it. 4. Click on Download Theme button. Your blogger template/theme will […]