VBA and Automation Tips Helping you save plenty of time by automating your work with simple scripts VBA scripts 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 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 slice and select DataFrame columns 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?
