Python
Pandas
Help Us
Cheat Sheet
Windows cmd vs Linux shell commands
Windows and Linux variable equivalents
Python Regex Cheat Sheet with Examples
Best Linux Cheat Sheet 2023
Complete Python Cheat Sheet
SoftHints - Python, Pandas, Linux, SQL Tutorials and Guides
Python
>
Python Basics
View all (24) →
How to Check if a Number is Odd Or Even in Python in 3 ways
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?
How get parent directory from file path in Python
What is Slicing in Python With Examples
>
Advanced Tutorials
View all (33) →
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
>
Python Errors
View all (7) →
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.
Pandas
>
Pandas Advanced
View all (8) →
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 Count
View all (3) →
Pandas: How to filter results of value_counts?
Pandas - value_counts - multiple columns, all columns and bad data
Pandas compare columns in two DataFrames
>
Pandas Column
View all (3) →
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
>
Pandas Basics
View all (3) →
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 DataFrame
View all (2) →
Pandas - Random Sample of a subset of a DataFrame - rows or columns
Pandas How to create DataFrame with Random Values N x M
>
Pandas Row
View all (1) →
Pandas : Select rows between two dates - DataFrame or CSV file
Linux Mint
>
User Interface
View all (9) →
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
>
Advanced Linux
View all (12) →
How to Performing HTTP Requests with cURL using PROXY
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
>
Troubleshoot
View all (14) →
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
Chrome Not Loading Pages Properly in Linux Mint
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
>
Video & Sound
View all (5) →
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
>
Linux Commands
View all (14) →
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
Data Base
>
MySQL
View all (12) →
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
>
SQL Basics
View all (8) →
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
>
Python
View all (4) →
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
>
DB apps
View all (3) →
How to import CSV file into MySQL 3 examples
MySQL Equivalent of Oracle's SQL loader
How to Export ER Diagram from MySQL
jupyter
>
JupyterLab
View all (7) →
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
>
Jupyter Tips
View all (6) →
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
>
Jupyter Display
View all (5) →
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
Regex
>
Regex in Text Editor
View all (5) →
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
>
Regex Basics
View all (5) →
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
>
Regex Match
View all (3) →
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
>
Regex Date
View all (2) →
Python Pandas extract URL or date by regex
python regex match date
PyCharm
>
PyCharm Advanced
View all (5) →
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
>
Git and PyCharm
View all (5) →
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 Error
View all (4) →
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
>
PyCharm Tips
View all (2) →
IntelliJ community edition add CSS and JSP syntax highlighting
Intellij open multiple projects or windows
Applications
>
Linux Mint Applications
View all (15) →
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
>
VIrtual Machine
View all (7) →
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
Other
>
Miscellaneous
View all (10) →
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
View all (3) →
Java robot key press, mouse move and click
Java 8 multiline string example
Java 8 Warning:java: target source value 1.5 is obsolete
>
Automation
View all (3) →
Selenium How to get text of the entire page
Python Tests with Headless Chrome Driver
Selenium select and extract text all possible ways
>
Windows
View all (2) →
windows rename files to lowercase
Concatenate files with command line Windows 7
>
Office
View all (1) →
Split text to columns
>
Cheat Sheet
View all (5) →
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
By using
SoftHints - Python, Linux, Pandas
, you agree to our
Cookie Policy.
Accept