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 divide DataFrame columns in Pandas? How to change a DataFrame column type to float, int and string with Python? How to add a series as a DataFrame column in Pandas? How to display all Pandas dataframe column names in Jupyter ? How to export a Python DataFrame to a csv file? Python: How to replace one or multiple characters in a string? Pandas: How to count number of elements after aggregating with groupby. How to delete one or multiple rows by index, condition and value in Pandas DataFrames? How to fix the module not found import error for urllib2? Find index of Pandas row values in Python dataframe columns How to save a Python Numpy array to a text file? How to write Python lists to txt and csv files? How to create a Python DataFrame from multiple columns in Pandas? How to plot time series with Python in Matplotlib and Pandas? How to drop columns by index from a Python DataFrame? How to rename one or more Python Pandas DataFrame columns? How to read one or multiple text files into a DataFrame with Python? How to convert a Python DataFrame column to float and int types? How to multiply two or more columns in Python DataFrames? How to select several columns in a Pandas DataFrame? How to insert a new row in a Pandas DataFrame? 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 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 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?
