teleren/devto huggingface dataset:
My First Hacktoberfest...
Tags: hacktoberfest
Published: 2020-11-05 09:46:00

✨My First Hacktoberfest... ✨ 


### Introduction
This was my first Hacktoberfest and I thoroughly enjoyed it. I exchanged 4 pull requests as per the guidelines and learned how to use GitHub. 

### Background
The idea and inspiration were given by my elder sister who is a software engineer and has been associated with the fest for the past 3 years. I have been taught by her how to proceed with the fest and what all has to be done.

### Progress
I am a beginner. I like the way GitHub has helped me to get my self introduced to various open-source code over the platform I wish to explore it more and would continue contributing to it.

###Contributions
I contributed in a project on CALCULATOR. I initially added percentage, average, power, remainder and sent pull requests for the same. Therefore, I completed 4 pull request successfully.

###Reflections
Overall, I enjoyed the Hacktoberfest 2020, it was really nice working with the open-source for the first time. I will surely participate again in the coming years. I have learned how to use GitHub successfully and also how to work with open-source. Yes, I have made a few connections while working with the project CALCULATOR @riya-17 @RakshitKumar04 . I am looking forward to building some new projects and contribute to GitHub and take help from GitHub for my upcoming project completion.
Build or buy your back-office software—is there a happy medium?
Tags: software, devops, 1c, developer
Published: 2020-11-05 09:43:46

Picking the right software is key for a changing business. The first step is choosing the implementation model — build or buy.

How to choose the model right for you, and minimize its risks? – [check out our latest blog!](https://1c-dn.com/blog/build-or-buy-your-back-office-software-is-there-a-happy-medium/)
I built a data platform to make finding datasets more accessible for everyone
Tags: showdev, datascience
Published: 2020-11-05 09:19:05

Link: https://stackup.sh/

**Tl;dr: I started a project to try and make large, clean, and reliable datasets easier for anyone to share for free or through a monthly subscription.**

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/nr377xhv79ucjxes2twu.gif)

## Why build this?

There's no doubt that there is a lot of value in structured data, especially in large quantities. But finding the correct datasets you need can usually be pretty tough and sometimes a bit messy. We also hear a lot about how tech giants gain so much value from data science because of the sheer amount of data they have control over.

So I decided to build stackup.sh to try and solve these problems:

1. Make the user experience of finding a good dataset as simple as possible.
2. By making data more accessible this can hopefully make the value of data science more available to anyone.

## What's next?

Right now the platform only has a single dataset available for tech news articles. I've used this to build a separate news feed for myself and also to learn some NLP algorithms. It's available for free and is updated every 30 minutes with new articles from a bunch of popular tech sources.

Over the next few weeks, I'll be sharing some more datasets I'm planning on using in other projects. If anyone is interested in helping me build out this platform by sharing their own data or requesting something they need, let me know!
Tailwind: Flex Col Justify Between Middle Full Height/Width?
Tags: help, tailwindcss, css, webdev
Published: 2020-11-05 09:16:00

I have this tailwind snippet:

```html
<div class="min-h-screen flex flex-col justify-between">
  <header class="p-4 bg-teal-500 text-center text-white font-bold">Header</header>
  <main class="h-64 bg-teal-600 flex items-center justify-center text-white">Main</main>
  <footer class="p-4 bg-teal-500 text-center text-white font-bold">Footer</footer>
</div>
```

and here is the preview:
![https://play.tailwindcss.com/](https://dev-to-uploads.s3.amazonaws.com/i/96w6oeulcj8c0i8i7hbm.png)

How to make the main section has full height that close the edges between header and footer?
How to fix - UnhandledPromiseRejectionWarning: MongoParseError: URI does not have hostname, domain name and tld
Tags: mongodb, node, javascript, tradecoder
Published: 2020-11-05 08:59:57

A solution for MongoParseError (UnhandledPromiseRejectionWarning: MongoParseError: URI does not have hostname, domain name and tld... )

```
(node:2436) UnhandledPromiseRejectionWarning: MongoParseError: URI does not have hostname, domain name and tld
    at parseSrvConnectionString (E:\mern\mongo-office\backend\node_modules\mongodb\lib\core\uri_parser.js:45:21)
    at parseConnectionString (E:\mern\mongo-office\backend\node_modules\mongodb\lib\core\uri_parser.js:587:12)
    at connect (E:\mern\mongo-office\backend\node_modules\mongodb\lib\operations\connect.js:282:3)
    at E:\mern\mongo-office\backend\node_modules\mongodb\lib\mongo_client.js:223:5
    at maybePromise (E:\mern\mongo-office\backend\node_modules\mongodb\lib\utils.js:662:3)
    at MongoClient.connect (E:\mern\mongo-office\backend\node_modules\mongodb\lib\mongo_client.js:219:10)
    at E:\mern\mongo-office\backend\node_modules\mongoose\lib\connection.js:791:12
    at new Promise (<anonymous>)
    at NativeConnection.Connection.openUri (E:\mern\mongo-office\backend\node_modules\mongoose\lib\connection.js:788:19)
    at E:\mern\mongo-office\backend\node_modules\mongoose\lib\index.js:342:10
    at E:\mern\mongo-office\backend\node_modules\mongoose\lib\helpers\promiseOrCallback.js:31:5
    at new Promise (<anonymous>)
    at promiseOrCallback (E:\mern\mongo-office\backend\node_modules\mongoose\lib\helpers\promiseOrCallback.js:30:10)
    at Mongoose.connect (E:\mern\mongo-office\backend\node_modules\mongoose\lib\index.js:341:10)
    at Object.<anonymous> (E:\mern\mongo-office\backend\server.js:11:10)
    at Module._compile (internal/modules/cjs/loader.js:1076:30)
(Use `node --trace-warnings ...` to show where the warning was created)
(node:2436) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 3)
(node:2436) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with
a non-zero exit code.

```

If you think everything in your MONGO_URI is ok but face this problem with mongoDB connection, 
## you can simply solve this issue by following these steps:

Check your MONGO_URI in `.env` file if your password has any special character like `#, @, !` and so on. 

If found, just change your password from the MongoDB account for that database username and make it without those characters. Use the new password to your MONGO_URI.

The problem is solved! Now run the server again.
Excel Formulas to Count Numbers by Range with COUNTIFS Function!!
Tags: excelformula, excelformulas
Published: 2020-11-05 10:10:42

---
title: Excel Formulas to Count Numbers by Range with COUNTIFS Function!!
published: true
date: 2020-11-05 08:58:33 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-numbers-by-range-with-countifs-function/
---

Here, we will discuss the simple **Formulas to count the numbers by a range with COUNTIFS Function in Excel Office 365**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to count numbers by range with COUNTIFS Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-numbers-by-range-with-COUNTIFS-Function.png)](https://geekexcel.com/excel-formulas-to-count-numbers-by-range-with-countifs-function/formulas-to-count-numbers-by-range-with-countifs-function/#main)<figcaption id="caption-attachment-16951">Formulas to count numbers by range with COUNTIFS Function</figcaption>
## General Formula:

- The following formula is used to count the numbers by a range using COUNTIFS Function in Excel.

**=COUNTIFS(range,”>=low”,range,”<=high”)**

## Explanations for Syntax:

- **COUNTIFS** – The Excel COUNTIFS Function will help to count the number of cells that meets multiple criteria or condition.
- **Range** – It represents the input range from your worksheet.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Operators (“>=” , “<=”) **– These operators are used to compare two numbers and find large and small values.

## Example:

- In the below screenshot, we will give the input range in  **Column C**.
- Then, enter the given formula in the selected field.
- Finally, we get the output in the selected **Cell F4**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-22.png)<figcaption id="caption-attachment-16952">Example</figcaption>

## Closure:

In this article, we described the **Formulas for counting the numbers by a range with COUNTIFS Function in Excel Office 365**. Hope that this article is useful to you. Kindly, leave your feedback in the below section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas for Calculating Age by Date of Birth ~ Easy Guide!!](https://geekexcel.com/excel-formulas-for-calculating-age-by-date-of-birth-easy-guide/)**
- [**Formulas for Counting Cells that Contain Negative Values in Excel!!**](https://geekexcel.com/formulas-for-counting-cells-that-contain-negative-values-in-excel/)
#codevember - 5 - Particles Brain - Made with tsParticles
Tags: codepen, javascript, html, showdev
Published: 2020-11-05 08:51:00

# Particles Brain

**Made with [tsParticles](https://github.com/matteobruni/tsparticles)**

{% codepen https://codepen.io/matteobruni/pen/ZEOjJGY %}

Checkout more samples on CodePen [here](https://codepen.io/collection/DPOage)
Formulas to Count Matches Between Two Columns in Excel!!
Tags: excelformula, excelformulas
Published: 2020-11-05 10:10:15

---
title: Formulas to Count Matches Between Two Columns in Excel!!
published: true
date: 2020-11-05 08:45:24 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-count-matches-between-two-columns-in-excel/
---

In this tutorial, we will discuss the **Formulas to count the matches between two columns in Excel Office 365** with brief explanations. Let’s get started!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to count the matches between two columns](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-the-matches-between-two-columns.png)](https://geekexcel.com/formulas-to-count-matches-between-two-columns-in-excel/formulas-to-count-the-matches-between-two-columns/#main)<figcaption id="caption-attachment-16936">Formulas to count the matches between two columns</figcaption>
## General Formula:

- Use the below formula to count the matches between two columns in Excel.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(–(range 1= range 2))**

## Explanations for Syntax:

- **SUMPRODUCT** – In Excel, the **[SUMPRODUCT Function](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)** will help to multiply the corresponding array or range and returns as the sum of the product.
- **Range** – It represents the input range from your worksheet.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Minus Operator (-)** – This symbol will help to subtract any two values.

## Example:

- Let’s consider the below image to count matches between two columns.
- First, you need to give the input ranges.
- After that, apply the given formula in the selected area.
- This formula will compare the two columns and count similar values in corresponding rows.
- Finally, you can get the output as given below.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-20.png)<figcaption id="caption-attachment-16940">Example</figcaption>

## Wind-Up:

From this article, you can easily understand the **Formula used for counting the matches between two columns in Excel Office 365**. Hope that this article is useful to you. Kindly, drop your feedback in the below comment box. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas for Counting Cells that End with a certain character or text!!](https://geekexcel.com/wp-admin/post.php?post=16809&action=edit)**
- **[Excel Formulas to Count Cells that do not contain Errors!!](https://geekexcel.com/wp-admin/post.php?post=16718&action=edit)**
Black Friday und Cyber Monday Angebote 2020 - Webmaster Edition
Tags: news, blackfriday, rabatt
Published: 2021-01-03 21:42:27

---
title: Black Friday und Cyber Monday Angebote 2020 - Webmaster Edition
published: true
date: 2020-11-05 08:38:00 UTC
tags: News,blackfriday,rabatt
canonical_url: https://j0e.org/black-friday-cyber-monday/
---

![Black Friday Deals](https://j0e.org/wp-content/uploads/2020/11/black-friday.png)

 Auch gibt es wieder sehr gute Black Friday und Cyber Monday Angebote für den Webmaster, …

[Black Friday und Cyber Monday Angebote 2020 - Webmaster Edition Weiter Lesen »](https://j0e.org/black-friday-cyber-monday/)
Ways to Improve eCommerce Conversion Rates

Tags: ecommerce
Published: 2020-11-05 08:37:30

The massive success of eCommerce giants Amazon and Flipkart is why the eCommerce industry has experienced tremendous growth in recent years and is predicted to hit a global revenue count of $4.88 trillion by 2021!  

In this competitive online buying world, some do’s and don’ts are motivating customers to buy items from your eCommerce shop. This article will discuss eCommerce conversion rates and share the best ways to <a href="https://www.sphinx-solution.com/blog/15-ecommerce-conversion-rates-hacks/">improve eCommerce conversion rate optimization</a>.

What is Conversion in eCommerce?
In Simple words, the eCommerce conversion rate is the percent of total site visitors that actually buy something from you.

How to Calculate Conversion Rate?
To calculate the conversion rate, all you have to do is divide the number of conversions you get during a specific time frame by the total number of people who visited your site or landing page and multiply it by 100.

Conversion Rate = (Conversions / Total Visitors) X 100 

Ways to Boost Your Ecommerce Conversion Rates:
1) Offer free shipping.
According to the NRF study, 75% of US consumers expect free shipping, even on orders under $50. Nowadays, Online shoppers expect more than free shipping. They want a certain standard that they have experience with Amazon.

2) Use High-Quality Product Images
Think about what customers want to see while shopping on your site. It’s images. When people shop online, they can’t touch the product or put it on. In this scenario, the best thing you can do is show high-quality product images so that the customer knows exactly what they are getting. 

3) Optimize Website Speed
According to Google, over 53% of mobile users will lose interest in your site if it takes more than three seconds to load. Even a one-second delay can cost you 7% reduction in conversions. 

4) Reduce Number of Step in Checkout
If you want to increase your conversion rate, the most important tip is to lower the number of checkout processes. In the study, Facebook found that “87% of consumers experience complex checkout steps will stop them from shopping online”

5) Offer Limited Period Coupon Codes
It’s a basic human tendency to fear for loss more than gain. Consumers hate missing out on a good deal on their favorite items. This opportunity will drive urgency among shoppers, and they will more likely go through with the purchase without getting distracted.

This Blog is originally published on Sphinx Website.
Order of events and script js 
Tags: javascript, react, beginners, devops
Published: 2020-11-05 08:32:12

I tried googling the answer but having trouble wording it.
I had a test today that asked me what would be the sequence for the following items.

I can only remember

Onload
DOMcontentloaded
script in head
script after body

Is there a word for this i wasnt sure what to search.

or a book someone recommends?
Free App Landing Page!
Published: 2020-11-05 08:21:00

Got a killer app idea but still undecided about how best to showcase it to the world? Easy! Just use one of our free React landing page templates custom made for app developers!

**App Modern** - our free React landing page template, is designed to highlight your kick ass app in front of the world. Visual aesthetics aside, our free React landing page templates include Next JS and Gatsby JS, making them super fast, secure and SEO friendly. On top of that, we have also implemented MailChimp integration making it super easy to keep in touch with your contacts.

So come take a look - we have got multiple free React landing page templates on several trending product niches that are sure to catch your eye. And if our current collection doesn't suit you, that's fine too - we are adding new templates each week we are sure we'll have something for you!

👉 Check it live here: https://startuplanding.redq.io/
👉 Check it on Github: https://github.com/Startup-Landing/Startup-Landing
👉 Check it on Producthunt: https://www.producthunt.com/posts/startup-landing
HookedElements: hooks in WickedElements 
Published: 2020-11-05 08:06:32

You missed hooks in WickedElements, don't worry anymore Andrea provided them for us :-)

You can test it here : [HookedElements](https://flems.io/#0=N4IgzgpgNhDGAuEAmIBcIB0ALeBbKIANCAGYCWMYaA2qAHYCGuEamO+RIsA9nYn6wA8AIwCu8eLwAEsKAzBgAvAB0u3UXwgAnVQD5BAejETeu5XRHjJdGXIUq1GxDpD6jV0+csmbs+UtUeJ209Q2NrXU5IGAQyXip0ACZUAGYUgFoABlRMkABfQnomFnQMACsqYh5NAXQDAykkCHI6CCkANzIGGQYoKGEGWABrKUkpLTgIMnaIMFGsNugIZj5xsgBzHCkGAHcGAE9zMlwAB24teClgJpaIQilRSABleAZEPKkSLW5cKQByLDcbhDZDpJYreBgP4AbnM5huZFaAAo-uFeBggpotH97uCIKtFLoruYpDJ4pdqJj4PdRCckG8IABdKSKB7PV6IJGZACUsJsUjxfAwvFkZGGLKkSO5LKJtPpnKpUgA1FIAIy8kkCmAQjCIAAe8AAwrx+JdWQADAAkwCpH1FwzA5r5eV5USWsXirAA7Kl8oUQIxmKwMQpONVTax8oy8kA)

```html
<button class="counter"></button>
<button class="counter"></button>
<button class="counter"></button>
```

```js
// define via callback to receives the element right away
import {define, useState} from 'hooked-elements';

define('button.counter', element => {
  const [count, update] = useState(0);
  element.onclick = () => update(count + 1);
  element.textContent = `${count} clicks`;
});
```
did you ever celebrate HacktoberFest ?
Tags: hacktoberfest
Published: 2020-11-05 07:27:58

<!-- ✨This template is only meant to get your ideas going, so please feel free to write your own title, structure, and words! ✨ --> 

Let's talk a bit about [Hacktoberfest](https://hacktoberfest.digitalocean.com), presented by [@DigitalOcean](https://www.digitalocean.com/):

_Hacktoberfest® is open to everyone in our global community. Whether you’re a developer, student learning to code, event host, or company of any size, you can help drive growth of open source and make positive contributions to an ever-growing community. All backgrounds and skill levels are encouraged to complete the challenge._
![Hacktoberfest](https://dev-to-uploads.s3.amazonaws.com/i/xxmkirexb8dtzzb19byf.png)

### A few lines about myself 👨‍💻
<!-- If you are new to the DEV community, introduce yourself and share a bit about why you joined DEV and decided to participate in Hacktoberfest this year.  --> 
My name is Jonas, just like Weezer's cool song. Since I have memory, life has been always using computer and trying new things using the tools that technology offers. My studies are in Information Technology and usually I'm building software at my current job at Wizeline, some other times I'm just playing videogames (Valorant) and spending time with friends and family.

### Background 🧑‍🚀
<!-- Are you brand new to open source? What about coding in general? Tell us about how you got here -->
Officially first time contributing to open source and participating  in Hacktoberfest, also proud to.

### Progress 🧑🏻‍🔧
<!-- Share a bit about where you’re at in your Hacktoberfest journey. What stage are you at? How has the process been?  -->
Hacktoberfest has finished and despite this horrible 2020 full of disappointments, Hacktoberfest is always a good thing to celebrate, a must in October, well I'm just speaking on behalf of all contributors. 

### Contributions 🧑‍💻
<!-- This is where you can list the contributions you made and explain why you chose the projects you did. Don’t forget to add links!  -->
They were more like first timer contributions but following the process and reading about all the documentation and issues in different open source projects was exciting. Hope to contribute more in the future.

### Reflections :sparkles:
<!-- Overall, how has your Hacktoberfest 2020 experience been? If you’re a first-timer, will you participate again? What have you learned? Have you made any interesting connections? What is your next step in open source?  -->
Certainly I will participate again and try to get involved in open source more often.

Cheers mates and `happy hacking`!
Write before you CODE
Tags: python, programming, javascript, codekaro
Published: 2020-11-05 07:55:54

Writing steps/points before coding, is something I started last month and have seen countless benefits !

Now the code comes out to be less buggy and more readable.

Even at times, when I complete a module and I know the whole picture of the project, then I am able to modify it along the way (without any worries) so that the code becomes more scalable.

It's better to write/draw steps before coding, even if it is not a best design.

Your views on making flowcharts or writing features before an attempt to coding ?