Jul 194 Data Analytics tasks that ChatGPT can do much faster & betterIn this article, I will show you how to use ChatGPT to do 4 common data analytics tasks. You can use ChatGPT at this link: https://chat.openai.com/chat 1. Extracting details from text ChatGPT can take text data like addresses, names, product reviews, and extract details from it. For example, let’s see how to extract street names…AI4 min readAI4 min read
Feb 5Use AI to talk to your databasesHave you ever wanted to just type what you need for your database Please show me all the users that signed up within the last week And then magically get the answer. Well, now you can do exactly that! 1. Go to the Love Spreadsheets website Go to www.lovespreadsheets.com and Sign Up for an account 2. Connect your database Currently, you…Artificial Intelligence2 min readArtificial Intelligence2 min read
Dec 6, 2022How to classify open ended text using AI & PythonOpenAI’s GPT-3 (Generative Pretrained Transformer 3) is a cutting-edge language processing model that can be used for a wide range of natural language processing tasks, including text classification. In this blog post, we’ll take a look at how to use GPT-3 to classify open-ended texts into categories, and we’ll include…AI3 min readAI3 min read
Nov 29, 2022Small businesses can win by using this simple tech strategySmall businesses always need to be up to date on the tech landscape to remain competitive with the larger players. So far in our tech enabled world, that has meant 2 things: An online presence (website, apps, directories) Marketing campaigns (email, Facebook ads, content) That will get you far, but…Data Science2 min readData Science2 min read
Nov 8, 20225 most popular ways to automate spreadsheet work1. Macros Macros are one of the most popular ways to automate spreadsheet tasks. By recording your actions in a macro, you can play back those actions later with the click of a button. This can save you a lot of time if you have to perform the same task repeatedly. 2. Add-ins There…Excel2 min readExcel2 min read
Oct 25, 2022Run SQL Queries on your Spreadsheet DataThere are 2 instances when you would want to run SQL queries on your Spreadsheet data You know SQL and doing your Data Analysis using SQL would be faster You want to learn SQL and need to practice on some real data In this article we highlight two methods on…Sql4 min readSql4 min read
Published inLevel Up Coding·Sep 12, 2022The fastest way to get a JSON APIYou’re a web developer and have recently gotten a new client, a local sandwich shop called Sam’s Supreme Sandwiches. They asked you to make a website for them where they can display the menu and in particular, the Sandwich of the Week. Every week, there will be a new Sandwich…API3 min readAPI3 min read
Published inLevel Up Coding·Jul 26, 202210 web dev projects you can build with spreadsheetsTake a look at your files. How many side projects do you have stacked up right now? We know that as a developer you have so many cool ideas of projects you want to build. You start building them, get stuck or realize how long something actually takes, stop, and…Webdev8 min readWebdev8 min read
Jul 26, 20225 Alternative Tools to Use Instead of Google Sheets APIThe Google Sheets API allows you to read, write, and format Google Sheets data with programming languages such as Python and JavaScript. However, as powerful as Google Sheets API is, it’s not for everyone, primarily because it requires substantial coding experience. Luckily, there are various API tools out there that…Spreadsheets5 min readSpreadsheets5 min read
Jul 19, 20227 reasons why you should use API Spreadsheets instead of Google Sheets APIWhat is API Spreadsheets? — API Spreadsheets is the leading platform to instantly use your spreadsheets as a REST API and database. It lets you connect your spreadsheets from various sources (as you will see below) and even lets you query your spreadsheet data! What is the Google Sheets API? Google Sheets provides an API to interact with your Google Sheets…Spreadsheets4 min readSpreadsheets4 min read
