Ayushi Rawatayushi7rawat.hashnode.net·Sep 19, 2020Web Scraping Coronavirus Data into MS ExcelYou can refer to my video tutorial for the same at YouTube https://www.youtube.com/watch?v=CTRYYz1u7Y8 Repository for Ultimate Resource in python. Drop a star if you find it useful! Got anything to add? Open a PR on the same! Coronavirus cases are i...77 likes·2.3K readsTechnical Tutorial - Python Projectsweb scraping
Alexandre Felipeafelipe.hashnode.net·Oct 11, 2022FeaturedShow the data!Introduction Probably these days is not necessary to teach people about importance that data has our world. It is often said that we live in the information age, and information is resolution of uncertainty, uncertainty usually makes us to feel uncom...62 likes·359 readsJavaScript
Mary Mbaomaomarrrz-lounge.hashnode.net·Jan 10, 2021Build Smarter Spreadsheets with PythonHi there, today's article shows us how Python makes spreadsheet creation and data manipulation more fun! First up, we discuss Excel, a spreadsheet package. This is a Microsoft Office tool which can be used to display data in a spreadsheet format. It...52 likes·770 readsPython
Idiomatic Programmersidiomaticprogrammers.hashnode.net·Apr 14, 2023How to download Pandas Dataframe as Excel or CSV in Django?Introduction Pandas is an essential tool used by Python developers used for data analysis purposes, but what is the point of the analysis if we are not able to provide that insight to the end user. When Django and Pandas are used in conjunction we ca...Python
Rashidat Jimohrashidatjay.hashnode.net·Mar 31, 2023Excel Data Validation: How to Ensure Consistent and Accurate Data Entry.In a standard Excel worksheet, users can input any data they like. Nothing is off-limits from whole numbers to decimals, lists, dates, texts, etc. They only need to double-click on the cell to input the data. However, allowing users to fill in any da...28 readsexcel
Code Buzzcodebuzz.hashnode.net·Mar 21, 2023Important Excel Formulas and Commands we need to knowSome of the important Excel formulas and commands are as follows: Column to comma-separated values =TEXTJOIN(",", TRUE, A:A) Select entire column Ctrl + Space Look for value from a column in table or list =VLOOKUP($A1, list2, 2, false) =VLOOKUP(A2,...Cheatsheetexcel
Sood Ruchikaruchikasood.hashnode.net·Mar 7, 2023How to combine 2 excel columns with a seperatorUse the below command to combine 2 excel columns with a seperator.You can apply it on one cell & then drag it to apply the same on the whole column =CONCATENATE(D3,",",E3)excel
Igor Rodionovrodionov5.hashnode.net·Mar 1, 2023How to Create PDFs From Excel Data With DynamicDocs Excel Add-inOne of the main features of DynamicDocs API is the ability to generate PDFs from JSON to PDF templates. As of today, the JSON to PDF template library consists of contracts, quotes, invoices, statements, proposals and more. To utilise this feature fur...pdf
Manav Pahilwanimanavpahilwani.hashnode.net·Feb 19, 2023How I won INR 5,000 at my first ever Hackathon (Solo)Hackathons!!! One of the most hyped concepts for all the engineering students out there. Being a data analyst and ML enthusiast, near the end of January I decided I'll participate in the first hackathon I come across. On 27th January, one of my profe...1 like·36 readshackathon
Suparna Dasexcelshorcuts.hashnode.net·Feb 9, 2023Excel shortcut keys you SHOULD know!What is Microsoft Excel? Microsoft Excel is a spreadsheet software developed by Microsoft Corporation. It allows users to create and manage spreadsheets, perform calculations, and analyze data. Excel provides a variety of tools and features that make...50 readsexcel
Eamonn Cottrelleamonn.hashnode.net·Dec 20, 2022How to Calculate Percentage Differences Between Two Numbers in Excel - Cell Percentage Change TutorialOriginally published for freeCodeCamp Spreadsheets are powerful and awesome. 💪 In this tutorial I will show you four ways to find the percentage difference between two numbers in Excel. I'll also show you how to use custom functions in Google Sheet...57 readsexcel
Amarachi Ejikeamyejike.hashnode.net·Jan 27, 2023Data ManipulationData are facts or statistics collected for analysis. They can be in various forms such as; Names, Ages, Weights, Addresses, Temperatures, distances and dates. These various forms of data can be used to conclude Data Manipulation Data manipulation is ...2 likes·30 readsData Science
Eamonn Cottrelleamonn.hashnode.net·Jan 27, 2023Excel Tutorial – How to Clean Data with the TRIM() and CLEAN() FunctionsOriginally published for freeCodeCamp Without clean data, your spreadsheet is knocking on death's door. In this tutorial, I will show you two fast ways to clean up the data in your Excel or Google Sheets spreadsheet. When dealing with data sets, esp...39 readsdata
