This piece of code was part of a larger project. I wanted to share what I learned to helpothers navigate how to access a Google Sheets file. In addition, I will discuss how to uploadan Excel file to a Google Sheets file Google Developer Console Setup Python Code: Downloading Google SheetsFile Python Code: Uploading File To GoogleSheets
This is one of my most used pieces of code, especially if I need to produce the same report for a number of different people. Let’s pretend you have a pivot table with a filter on user and you want to give a copy of the pivot table to each user. You could manually change the filter on the pivot table and then save the file yourself. Or,...
You can dictate the naming convention of a file and have a macro save it automatically There are 2 examples below PDF Based On Pivot Table Filter Save Workbook In Specified Location Asxlsx With Date Stamp
I found this dataset on kaggle. I thought it would be fun to build a few charts and see whatconclusions could be made. This dataset is only for 3 months of data. Initial Exploration Deeper Analysis
Introduction Data Sources Methodology & Exploration Using Foursquare API, We Can Pull In All Restaurants In Manhattan Within A Specified Range And Observe: There Are 2K+ Restaurants &122 Types Of Restaurants. In Addition, We Can Assess Frequency By Top 10 Restaurants Within Each Neighborhood. In The Dataset, We Can Determine Both The Number Of Japanese Restaurants And Total Restaurants. We Can Pull In Adjusted Gross Income (AGI) By...
All rights are reserved.
