SoftHints - Python, Pandas, Linux, SQL Tutorials and Guides

<!--kg-card-begin: html-->Python<!--kg-card-end: html-->

Python

How to Check if a Number is Odd Or Even in Python in 3 ways featured icon

How To find consecutive numbers in a list in Python?

How To Iterate Over Chunks of Data in Python - 3 Examples

If else in list comprehension Python

How do you make a Counter in Python? featured icon

How get parent directory from file path in Python

What is Slicing in Python With Examples

How to Find Broken Links With Python

How To Download Entire Slack Channel History with Python?

How to Handle Dynamic Content when Scraping a Website with Python and BeautifulSoup?

How to scrape page with Python Requests and BeautifulSoup

How to Scrape Site with Infinite Scrolling - Python + Selenium

How to get currency data in Python?

How to impersonate browser in Python - http fingerprint requests

TabError: inconsistent use of tabs and spaces in indentation - Python

How to solve ImportError: No module named pip in Python

Python index ValueError: substring not found

Python SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

Python NameError: name 'self' is not defined

Python 3 SyntaxError: invalid syntax f strings

Python dependency error modules has requirement which is incompatible.

<!--kg-card-begin: html-->Pandas<!--kg-card-end: html-->

Pandas

How to Merge Multiple JSON Files with Python

How to Use Like Operator in Pandas DataFrame

Pandas TypeError: unhashable type: 'list'/'dict'

Pandas : Crosstab - cross tabulation of two (or more) factors - usage and examples

Python read huge JSON file with Pandas

Python 3 ImportError: No module named 'pandas.core.indexes'

Python cumulative sum per group with pandas

Pandas: How to filter results of value_counts?

Pandas - value_counts - multiple columns, all columns and bad data

Pandas compare columns in two DataFrames

How to Show All Columns, Rows and Values in Pandas

Pandas: Check If Value of Column Is Contained in Another Column in the Same Row

Pandas count and percentage by value for a column

Python Pandas How to Concatenate Two Columns

Python Pandas 7 examples of filters and lambda apply

text/CSV file to dataframe with Python and pandas

Pandas - Random Sample of a subset of a DataFrame - rows or columns

Pandas How to create DataFrame with Random Values N x M

Pandas : Select rows between two dates - DataFrame or CSV file

<!--kg-card-begin: html-->Linux Mint<!--kg-card-end: html-->

Linux Mint

How to Disable Workspace Switching Sound in Linux Mint

Split screen, move windows and maximize on Linux mint/Ubuntu

Linux Mint add Google Calendar on your desktop

Linux Mint 19 How to change user password

Linux Mint 19 Add Shortcuts to Panel

Simple ways to create shortcut in Linux Mint 19

Linux Mint 19 How to edit Main Menu

How to automatically switch between dark mode and light mode in Linux Mint and Ubuntu

How to Dynamically Build Command and Execute - Shell Script

How To Download Linux Mint Backgrounds

How to Install Viber on Linux

How to Recover a Deleted File on Linux Mint or Ubuntu

How to Completely Remove Flatpak - Linux Mint

How to Merge multiple CSV Files in Linux Mint

How to Fix Wine Encoding Issues in Ubuntu

How to Fix: SSH Failed Permission Denied (publickey) -Ubuntu

How to List, Remove and Update Flatpak Packages in Linux Mint

Upgrade to nodejs 18 Error: connect ECONNREFUSED ::1:3306 Ghost + Ubuntu featured icon

Chrome Not Loading Pages Properly in Linux Mint featured icon

Linux MInt - W: Key is stored in legacy trusted.gpg keyring (/etc/apt/trusted.gpg), see the DEPRECATION section in apt-key(8) for details.

How to Setup Printer and Fix Printing Problems in Linux Mint

pulseaudio Daemon startup failed - Linux Mint

HDMI/DP Monitor no signal but recognized Linux Mint 19

Linux Mint 19 solutions for sound and video problems

Linux Mint identify, fix sound problems, set default device

Install latest NVIDIA drivers for Linux Mint 19/Ubuntu 18.04

How to Pass, Modify and Pipe Output to Next Command in Bash

How to Replace Substring from String - Bash

bash random number in range

What are bash shell variables?

How to Add a New Line to the Output in Bash?

How to Save a cURL Output to a File?

Easily Convert JSON to JSON lines in Linux jq

<!--kg-card-begin: html-->Data Base<!--kg-card-end: html-->

Data Base

How to Easily Backup MySQL Database

How To Create a New User and Grant Permissions in MySQL

MySQL 8 Access denied for user 'root'@'localhost'

How to reset user password Ghost 2 blog MySQL

MySQL Workbench 8 unsupported operating system for Linux Mint

MySQL 8 Set or reset user password

MySQL convert column to row unpivot example

MySQL how to split and/or transform a string

MySQL 8 how to select day, month and year from date

Count words and phrases in a column MySQL/SQL

MySQL select min and max length of all table columns

mysql select N max values per group

Group by and string concatenation in Oracle and MySQL

MySQL How to find highest and lowest value

How to Convert MySQL Table to Pandas DataFrame / Python Dictionary

Insert multiple rows at once with Python and MySQL

Python 3 convert dictionary to SQL insert

Python read, validate and import CSV/JSON file to MySQL

How to import CSV file into MySQL 3 examples

MySQL Equivalent of Oracle's SQL loader

How to Export ER Diagram from MySQL

<!--kg-card-begin: html-->jupyter<!--kg-card-end: html-->

jupyter

How to Hide Sidebars, Navigation, Header in JupyterLab

Invalid Server Password in JupyterLab and Jupyter Notebook

How to Add/Run/Save Code from .py Into Jupyter Notebook Cell

JupyterLab Select, Move and/or Merge Multiple Cells

How to Delete All/Markdown Cell in Jupyter/JupyterLab

6 ways to Recover deleted Jupyter Notebook (including JupyterLab)

Ubuntu 18 how to install Jupyter Notebook/IPython

How to Automatically Create Jupyter Notebooks - Python + Nbformat

How to increase cell width of Jupyter Notebook

How to Set and List Environmental Variable in Python and Jupyter Notebook

How to Open JupyterLab Notebook Without the Output

Jupyter/iPython Notebook download files as CSV, zip

Python and Jupyter save and download CSV file

How to Show 'Error message' Without Stack Trace in JupyterLab

How to Turn off Warnings in JupyterLab(Jupyter Notebook)

How to Display Two Pandas Dataframes side by side in Jupyter Notebook

IPython/Jupyter Notebook tricks for advanced in 2019

How to create Jupyter Notebook in PyCharm

<!--kg-card-begin: html-->Regex<!--kg-card-end: html-->

Regex

Use Regex To Remove lines containing word in Sublime

Sublime 3 Regex Search and Replace Examples

Sublime Text 3 tricks: compare files, highlight and regex

Notepad++ regex replace capture group examples list

Notepad++ regex replace wildcard capture group

How to Match text between two strings with regex in Python

Regex for Phone Number Find and Validation in Python

Python Regular Expression Matching Multiline Comments and Docstrings

Java regex match abbreviations 5 examples

java regex matcher example

How to Match Strings Not Starting With Pattern using Regex and Python

Regex to Match no space or one space in Python

python regex match examples

Python Pandas extract URL or date by regex

python regex match date

<!--kg-card-begin: html-->PyCharm<!--kg-card-end: html-->

PyCharm

PyCharm How to restore deleted file

Run and debug Scrapy projects with PyCharm

PyCharm exclude folders from indexing, find and show usages

How to install Python 3.7 and setup PyCharm on Linux Mint 18/19

IntelliJ Debug, conditional breakpoints and step back

PyCharm how to delete a git branch locally and remotely

PyCharm Github Push failed: Repository not found

PyCharm/IntelliJ 18 change Git user

PyCharm Version Control and git complete tutorial for beginners

IntelliJ Idea Integrating with Bitbucket repository

PyCharm virtualenv ModuleNotFoundError: No module named 'distutils.core'

No Python Interpreter Configured For The Module - PyCharm/IntelliJ

IntelliJ IDEA Error Loading Project: Cannot load facet Python

Intellij IDEA 2018 unable to resolve class

IntelliJ community edition add CSS and JSP syntax highlighting

Intellij open multiple projects or windows

<!--kg-card-begin: html-->Applications<!--kg-card-end: html-->

Applications

How to Automatically Switch Between Light and Dark Themes in Sublime

How to Compare Files in Sublime Text 4

how to install julia in linux mint

How to Convert PDF to ePUB with Linux

How To Install Node.js on Linux Mint

How to Install Visual Studio Code on Linux Mint

How to Install Microsoft Teams on Linux Mint

VirtualBox black or blank screen issues Ubuntu/Linux Mint

Play Fortnite on Linux with virtual machine

Create virtual machine with VMware player 15 Linux Mint/Windows

How To Install VMware Player on Ubuntu 18.04/ Mint 19

How to Install VMware Player 14 on Ubuntu 18

Ubuntu Server VM: not working copy paste

Ubuntu Linux add VirtualBox Guest Additions

<!--kg-card-begin: html-->Other<!--kg-card-end: html-->

Other

How to Download Videos from Any Website in 2024

How To Fix Visual effects on Google Meet - Chrome?

How to Fix CopyQ Autostarts Without Tray Icon

Online Banking for Remote Workers and Developers

Comparison: Linode vs DigitalOcean - best VPS in 2023

How to Recover Unsaved Files in Sublime 4 Linux Or Mac

apex legends the game requires directx 11.0 feature level video card

Java robot key press, mouse move and click

Java 8 multiline string example

Java 8 Warning:java: target source value 1.5 is obsolete

Selenium How to get text of the entire page

Python Tests with Headless Chrome Driver

Selenium select and extract text all possible ways

windows rename files to lowercase

Concatenate files with command line Windows 7

Split text to columns

Complete Python Cheat Sheet

Best Linux Cheat Sheet 2023

Python Regex Cheat Sheet with Examples

Windows and Linux variable equivalents

Windows cmd vs Linux shell commands