VBA and Python Tutorials Helping you save plenty of time by automating your work with simple scripts VBA scripts How to check if a file or folder exists in your computer with Excel VBA? How to check if a cell or a range of multiple cells is empty with Excel VBA? How to set an Excel cell color according to a condition with VBA? How to set an Excel spreadsheet column width with VBA? How to make a Macro in Microsoft Visio? How to work with Message and Input Boxes in PowerPoint VBA? How to subset a dataframe by one or multiple columns? How to create and insert shapes in PowerPoint with VBA? How to create and add slides to PowerPoint presentations with VBA? How to display the developer tab in Excel, Outlook and Word 2019 / 365? How to copy add slides into your PowerPoint presentation with VBA Macros? Python Automation and Data Analysis How to delete rows with null / missing (NAN) values from your Python DataFrame? How to filter a Pandas DataFrame by specific column and row values? How to find the standard deviation of DataFrame columns, series and rows in Pandas? How to concatenate and combine two or more Pandas DataFrame columns? How to remove the first column of a Pandas DataFrame? How to drop one or multiple columns in a Pandas Dataframe? How to plot a continuous function with Python using Matplotlib and Seaborn? How to count unique specific values in a Python DataFrame column? How to use the Pandas groupby and then sum in Python DataFrames? How to sum specific multiple rows in a Pandas DataFrame? How to slice and select DataFrame columns in Python? How to add a new column to a DataFrame in Python Pandas? How to solve the no module named Seaborn error in Python? How to plot a bar chart with Python and Pandas? How to read a .tsv file with Python? How to convert Pandas DataFrame columns to string type? How to sum all, multiple and specific columns in a DataFrame? How to pip install the requests module to solve import errors? How to sort a Python Dataframe by one or multiple columns? How to calculate the average of one or more columns in a Pandas DataFrame? Pandas: How to group a dataframe by one or multiple columns? How to export and save a Pandas Dataframe to excel, csv and pickle? How to subset Dataframe rows by multiple conditions and columns with the loc indexer in Python? How to make an empty Pandas DataFrames with Python and append data to it? How to add columns to a Python Pandas DataFrame ? How to convert a list to a Pandas DataFrame with Python? Adding new rows to Pandas DataFrames: from list, from dictionary, from Series How to build a numpy array from a Python DataFrame? How to insert multiple columns to a Pandas DataFrame? How to move a column to the first position in a Python DataFrame? How to modify values in a Pandas DataFrame? How to convert a list to a dictionary in Python? How to pip install pandas to fix not found or import errors? How to split a string into two halves in Python? How to remove newlines from a string in Python 3? How to write lists and dictionaries into a CSV file with Python 3? How to print a string in reverse in Python 3? How to open and read an excel file with Python? How to write text files in Python 3? How to convert a Python string to Hex format? How to find unique occurrences in a Python list? How to round up a float number in Python? Convert a list of strings to float numbers in Python? How to read from an SQL database with pd.read_sql in Python? Output Pandas DataFrame to Excel (one or multiple worksheets) with Python How to write Python / Pandas rows and columns into a list?
