Overview Learn how to build an accurate forecast in Excel – a classic technique to have for any analytics professional…
Continue Readingexcel
Tyler Folkman
Stop Using Excel for Data Analytics: Upgrade to PythonHow To Tag Any Image Using Deep LearningWith Pytorch Lightning!The Ultimate Guide to Linear…
Continue Reading3 Ambitious Excel Charts to Boost your Analytics and Visualization Portfolio
Overview Excel charts are a powerful way to showcase your analytics profile Here are three ambitious Excel charts every analyst…
Continue ReadingPredictive Modeling in Excel – How to Create a Linear Regression Model from Scratch
Overview You can perform predictive modeling in Excel in just a few steps Here’s a step-by-step tutorial on how to…
Continue Reading3 Advanced Excel Charts Every Analytics Professional Should Try
Overview Advanced Excel charts are a great way to create effective and impactful stories for our audience Learn 3 advanced…
Continue Reading5 Powerful Excel Dashboards for Analytics Professionals
Overview Dashboards are ubiquitous in the industry. Every analyst should be well versed with how to create dashboards Excel is…
Continue Reading3 Classic Excel Tricks to Become an Efficient Analyst
Overview Learn 3 classic Excel tricks in this article that will impress your audience Use these Excel tricks in your…
Continue ReadingUltimate Guide to Cleaning Data with Excel and Google Sheets
The “Ultimate Guide to Cleaning Data with Excel and Google Sheets” eBook by Inzata Analytics discusses how poor data quality…
Continue ReadingExporting Excel files to CSV with in2csv
This post shows how to export an Excel file to a CSV file using in2csv from the csvkit package. You…
Continue ReadingCostas Andreou
Learn How to Quickly Create UIs in PythonFinally a library you can pick up in under 5 minutesAn Introduction to SQLLearn the basics…
Continue ReadingExcel, R, and Unicode
I received some data as an Excel file recently. I cleaned things up a bit, exported the data to a…
Continue ReadingWorking with Spreadsheets using Python
This is the functionality we needed. But how did we achieve this?Here is what happened. First you read “sample. xls”…
Continue ReadingJupyter is the new Excel
should start using Jupyter Notebooks as an alternative powerful analytical tool. Excel HeavenA few factors have made Excel so valuable,…
Continue ReadingAutomating excel files using Pandas
Automating excel files using PandasAkash ChandraBlockedUnblockFollowFollowingMay 28Python is increasingly becoming popular among data science and analytics enthusiasts. The topmost reasons that…
Continue ReadingStephen Fordham
Pandas and SQL together, a Premier League and Player Scouting ExamplePandas, SQL, Excel data transferQuerying the Premier League using Python and SQL CombinedFrom…
Continue ReadingCitizen Data Science: Analyze Nature Without Programming
Citizen Data Science:Analyze Nature Without ProgrammingUsing Excel with iNaturalist and eBirdJohn HurleyBlockedUnblockFollowFollowingMay 15Steven Wright @stevenwright via UnsplashI recently gave an informal talk…
Continue ReadingQuerying the Premier League using Python and SQL Combined
Querying the Premier League using Python and SQL CombinedFrom Excel to MySQL via Python, and then back to ExcelStephen FordhamBlockedUnblockFollowFollowingMay 9It may…
Continue ReadingQuerying the Premier League
Querying the Premier League-Using MySQL with PythonStephen FordhamBlockedUnblockFollowFollowingMay 9It may be useful sometimes to convert an Excel sheet into a MySQL database.…
Continue ReadingR 技術文 — 區議會選區分界變動及人口地圖
R 技術文 — 區議會選區分界變動及人口地圖EricBlockedUnblockFollowFollowingMay 3¾ 技術文 — 用 R 製作區議會選區資料地圖 (上)以 R 製作互動式網頁地圖顯示香港區議會選區分界 (附完整原始碼)medium. com上文用簡單例子講點用 R 製作區議會選區地圖,相信唔少人(點解會咁天真覺得有唔少人睇呢啲技術文) 到喉唔到肺,今日深入少少,首先講吓用 leaflet 繪製地圖嘅常用進階選項,再講點解讀 PDF 檔同埋將人口數據加返落各個選區。(完整即食原始碼放喺各章節底,已合併前文相關代碼,唔駛前抄後抄咁辛苦)A. 區議會選區分界變遷上文提到點用 leaflet…
Continue ReadingComparing and Matching Column Values in Different Excel Files using Pandas
Comparing and Matching Column Values in Different Excel Files using PandasStephen FordhamBlockedUnblockFollowFollowingMay 3Pandas for column matchingOften, we may want to compare…
Continue ReadingAutomate Site Serve Reporting with Prisma Media Plan and Python for Media Agencies
Automate Site Serve Reporting with Prisma Media Plan and Python for Media AgenciesHarrison ChawBlockedUnblockFollowFollowingApr 12Photo by Franck V. on UnsplashIn order to…
Continue ReadingWhen Excel isn’t enough: Using Python to clean your Data, automate Excel and much more…
@headwayioWhen Excel isn’t enough: Using Python to clean your Data, automate Excel and much more…How a Data Analyst can survive in…
Continue ReadingTo Learn Excel or Lisp? A Programmer’s Dilemma
A Programmer’s DilemmaGeorge AcevedoBlockedUnblockFollowFollowingJan 13Photo by Vladislav Babienko on Unsplash“An investment in knowledge pays the best interest,” says Benjamin Franklin. But…
Continue ReadingWriting to Excel with Python | MicroPython
Writing to Excel with Python | MicroPythonAlise Otília RamírezBlockedUnblockFollowFollowingJan 2Excel remains a prominent tool for data analysis and data visualization,…
Continue ReadingHome Remodeling Analysis Turned Excel Data Handling in Python
Home Remodeling Analysis Turned Excel Data Handling in PythonWhy cleaning data is the most important stepManjula MishraBlockedUnblockFollowFollowingDec 14Original Project Mission: Find…
Continue Reading