teleren/devto huggingface dataset:
Hacktoberfest : get more than a T-Shirt
Tags: hacktoberfest, beginners, opensource, github
Published: 2020-10-09 12:38:06

Hello people!
I am Vikas Singh. I like to document what I learn every day. I am a teacher by passion and a UI UX designer by Profession. Apart from that, I love to teach people and share my knowledge with them. This is going to be my first post on Dev.to. __If you are new to Open-source community and want to get started right now, then you must read this post.__


As this is the month of October, So Hactoberfest is going on. Well! Hacktoberfest 2020 is a program powered by the digital ocean in partnership with Intel and Dev to promote the open-source. 


Here open source points to the open-source projects, open-source software and open-source organizations. Examples of open-source software include VLC Media Player, Mozilla Firefox, Linux, WordPress and the number tends to infinity. 


If a project or software is open source, this means that its source code, documentation, and the user interface are made public and you are free to modify the code, add new features, fix bugs and redistribute it.


By the way, Digital ocean is an American organisation that helps the fellow developers to deploy their apps and websites on the cloud.


Here __deploying an app or website__ means making it publicly available. This helps all the developers, designers and the whole team to get quality feedback and this way they can improve their app or website. 


It is not like that Hacktoberfest is only for coders but if you are not a coder! don't worry, you can also participate in Hacktoberfest 2020. Like you can contribute to the UI(user interface), UX(user experience) and documentation of any open-source software. 

##__Get Much more than a T-Shirt__

To participate in Hacktoberfest, you have to make 4 valid pull requests on the repositories marked with Hacktoberfest and Hacktoberfest-accepted labels. This wins you a Free Limited edition Hacktoberfest Tshirt. You can also choose to plant a tree rather than getting a Tshirt.


This time Hactoberfest has introduced some great changes in order to stop the spammers. Spammers are the one here who are just making meaningless contributions in order to get a free T-shirt.

I really appreciate the new opt-in only method introduced by the digital ocean. Well! Hacktoberfest and open source can help you to get just more than a Tshirt like you can earn a big amount of money through open source contributions.


##__Earn By Contributing to Open Source__
If you really want to earn from Open Source, there are numerous programs like Google Summer of Code, Outreachy and many more which give you a decent amount of money like up to $5000 for 3 months for supporting the open-source organizations.


Moreover, you will learn to collaborate with the team members on GitHub, you will learn git, you will learn how realtime Products are developed and a lot more. 


So this was a kind of introduction about Hacktoberfest and open source. 

__ALERT__: If you have any suggestions do comment out! 
__ALERT__: If you find this post informative! do me a favour by sharing this post.
Create a blog app with user authentication by using React and ROR
Tags: react, rails, webdev, productivity
Published: 2020-10-09 12:30:57

## Quick Overview
In a previous article, I talked about how to create a simple CRUD app with React and ROR. 
Now its time to implement user authentication and some other features.

# Updates
* User authentication
* Add custom images
* User Profile
* UI changes

# Built with
* Ruby on Rails
* Reactjs (context api, react hooks, react-router)
* React-icons
* ChakraUI
* Formik

**Live Demo:** [BlogApp](https://blog-frontend-react.herokuapp.com/)
**GitHub Repos:**
[reactFrontend](https://github.com/MA-Ahmad/blog-app-react-frontend) 
[backendApi](https://github.com/MA-Ahmad/blog-app-rails-backend)
Merge Adjacent Cells in Columns with Same Data/Value in Excel!!
Tags: kutoolsexceltutorial, stepstomergeadjacent, kutools
Published: 2020-10-12 12:01:42

---
title: Merge Adjacent Cells in Columns with Same Data/Value in Excel!!
published: true
date: 2020-10-09 12:21:13 UTC
tags: KutoolsExcelTutorial,stepstoMergeAdjacent,Kutools
canonical_url: https://geekexcel.com/merge-adjacent-cells-in-columns-with-same-data-value-in-excel/
---

In this article, you will learn the steps to **Merge Adjacent Cells in Columns with Same Data/Value in Excel Office 365** using **Kutools.** 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)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Merge Adjacent Cells in Columns:

To merge adjacent cells in columns with the same data/value, do as follows.

- You need to select the range that you need to merge the cells with the same data.

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

- Go to the **Kutools Tab, select** the **Merge & Split** option, then **choose** the **Merge Same Cells** option from the menu.

![Select the Merge Same Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Merge-Same-Cells-option.png)<figcaption id="caption-attachment-15554">Select the Merge Same Cells option</figcaption>

- Now, the adjacent cells have the same value that will be merged as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-9.png)<figcaption id="caption-attachment-15555">Result</figcaption>

From the above image, you can easily understand how this option can be used to merge adjacent cells in a column in Excel.

## Conclusion:

In the above article, you can clearly understand the steps to **Merge Adjacent Cells in Columns with Same Data/Value in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Insert Multiple Checkboxes at Once](https://geekexcel.com/insert-multiple-checkboxes-at-once-in-excel-office-365/)
- [Convert Cell Formulas to Text Strings in Excel ](https://geekexcel.com/how-to-convert-cell-formulas-to-text-strings-in-excel-office-365/)
Your biggest fears about transitioning to a web dev career, addressed! 😱
Tags: codenewbie, beginners, career, webdev
Published: 2020-10-12 16:23:05

---
title: Your biggest fears about transitioning to a web dev career, addressed! 😱
description: These four questions people ask me have shown me what aspiring web developers are afraid of. I take some time to talk you through them to help mitigate those fears.
published: true
date: 2020-10-09 12:11:00 UTC
tags: codenewbie,beginners,career,webdev
canonical_url: https://raddevon.com/articles/your-biggest-fears-about-transitioning-to-a-web-dev-career-addressed/
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/26npjtyy53pihrso87nn.jpg
---
I talk to a lot of people who are transitioning into web development careers. These are the four questions they that reveal your greatest fears about changing careers.

{% youtube 0k2dFN6x4jg %}

🧰 Resources 🧰
-----------------------------------------------------------------------------------------------------------------------------------------

*   🔧 [Read more about age bias in hiring web developers and how to overcome it](https://raddevon.com/articles/am-i-too-old-to-become-a-web-developer/)
*   🔧 [Learn to get experience before you get your first job](https://raddevon.com/articles/get-a-web-development-job-without-experience/)

If you’re sold on freelancing having watched the video, or even if you’re just curious to know more about what it would be like to start freelancing, sign up for [my **Freelancing Crash Course**](https://raddevon.com/enroll-in-the-freelancing-crash-course/)! It’s free and comes straight to your inbox.
The Cloud Firestore
Tags: computerscience, codenewbie, react, javascript
Published: 2020-10-09 12:09:12

###Cloud Firestore is one of the most powerful and sophisticated online databases in the world.
It is a document database.It stores your data in a tree-like structure, similar to a Real time Database but everything is placed into **documents and collections**.
You can think of a document as a JavaScript object. It has key-value pairs which are referred to as **fields**, and the values of these fields can be any number of things, from strings to numbers to binary values and maps.
Documents collected together form **Collections**.

1.These collections can only contain documents.
2.Documents can't contain other documents but they can point to sub-collections. In this type of data structure, when you grab data from a document, you will only grab that document and not any other documents contained in any of the sub-collections. 
3.The root of your database can only consist of collections.

Just like the Real time database, Cloud Firestore implementation contains a set of security rules that determine whether or not a certain action is permitted.
Just like the Real time database, Cloud Firestore allows you to listen to changes in the database and update my app in real time.

Cloud Firestore makes your app run as speedy as possible, by notifying you of the changes happening locally as if they had happened on the server. In the mean time it is still going ahead and updating that data remotely in the background.
Reverse Text String or Words Order in Excel Office 365!!
Tags: kutoolsexceltutorial, stepstoreversetextst, kutools
Published: 2020-10-09 12:10:33

---
title: Reverse Text String or Words Order in Excel Office 365!!
published: true
date: 2020-10-09 12:08:23 UTC
tags: KutoolsExcelTutorial,StepstoReverseTextSt,Kutools
canonical_url: https://geekexcel.com/reverse-text-string-or-words-order-in-excel-office-365/
---

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)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Reverse Text String or Words Order:

- First, you need to **select the data range** that you want to reverse.

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

- Then, on the **Kutools Tab,**   **select** the **Text** option, **choose** the **Reverse Text Order** option.

![Select the Reverse Text Order option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Reverse-Text-Order-option.png)<figcaption id="caption-attachment-15522">Select the Reverse Text Order option</figcaption>

- It will open the **Reverse Text dialog box**.
- You need to select the separator and **click** the **OK** button.
- If you specify the **Nothing** option under the **Separator,** you can get the output as shown in the below screenshot.

![Reverse Text Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Reverse-Text-Dialog-Box.png)<figcaption id="caption-attachment-15523">Reverse Text Dialog Box</figcaption>

### Output:

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-21.png)<figcaption id="caption-attachment-15524">Output</figcaption>

- If you specify the **Comma** option under the **Separator** section, you will get the result like the following image.

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

## Verdict:

In the above article, you can clearly understand the steps to **Reverse Text String or Words Order in Excel Office 365** using **Kutools. ** Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [Print Current Printed Page of Active Cell in Excel](https://geekexcel.com/print-current-printed-page-of-active-cell-in-excel-office-365/)
- [Protect Multiple Worksheets at a Time ](https://geekexcel.com/protect-multiple-worksheets-at-a-time-in-excel-office-365/)
Insert File Name and File Path into Cell, Header or Footer in Excel!!
Tags: kutoolsexceltutorial, stepstoinsertfilenam, kutools
Published: 2020-10-09 12:10:24

---
title: Insert File Name and File Path into Cell, Header or Footer in Excel!!
published: true
date: 2020-10-09 12:02:26 UTC
tags: KutoolsExcelTutorial,StepstoInsertFileNam,Kutools
canonical_url: https://geekexcel.com/insert-file-name-and-file-path-into-cell-header-or-footer-in-excel/
---

In this article, we are going to see how to **Insert File Name and File Path into Cell, Header, or Footer in Excel Office 365** using **Kutools. ** 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)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## **Inserting File Name and File Path into Cell, Header, or Footer:**

- On the **Kutools Plus Tab, select** the **Workbook** option, then **choose** the **Insert Workbook Information** from the drop-down list.

![Choose the Insert Workbook Information option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-the-Insert-Workbook-Information-option.png)<figcaption id="caption-attachment-15530">Choose the Insert Workbook Information option</figcaption>

- It will open the **Insert Workbook Information dialog box.**
- **Information** – You need to specify the information that you want to insert.
- **Range** – You need to select the range where you want to insert the workbook information.
- You need to **select** the **header or footer** option.
- Then, **click** the **OK** button.

![Insert Workbook Information Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Insert-Workbook-Information-Dialog-Box.png)<figcaption id="caption-attachment-15531">Insert Workbook Information Dialog Box</figcaption>

- The workbook saving path and workbook name have been inserted in the header of the current worksheet.
- You can preview the sheet by selecting the **Page Layout** option under the **View Tab.**

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

## **Verdict:**

In this article, you can clearly understand the steps to **Insert File Name and File Path into Cell, Header, or Footer in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [Convert Cell Formulas to Text Strings in Excel](https://geekexcel.com/how-to-convert-cell-formulas-to-text-strings-in-excel-office-365/)
- [Insert Title Rows into a Range in Excel](https://geekexcel.com/insert-title-rows-into-a-range-in-excel-office-365-kutools/)
Daily Developer Jokes - Friday, Oct 9, 2020
Tags: jokes, dailydeveloperjokes
Published: 2020-10-09 12:00:16

---
title: "Daily Developer Jokes - Friday, Oct 9, 2020"
description: "Check out today's daily developer joke! (a project by Fred Adams at xtrp.io)"
series: "Daily Developer Jokes"
cover_image: "https://private.xtrp.io/projects/DailyDeveloperJokes/thumbnail_generator/?date=Friday%2C%20Oct%209%2C%202020"
published: true
tags: #jokes, #dailydeveloperjokes
---

Generated by Daily Developer Jokes, a project by [Fred Adams](https://xtrp.io/) ([@xtrp](https://dev.to/xtrp) on DEV)

___Read about Daily Developer Jokes on [this blog post](https://xtrp.io/blog/2020/01/12/daily-jokes-bot-release/), and check out the [Daily Developer Jokes Website](https://dailydeveloperjokes.github.io/).___
### Today's Joke is...
![Joke Image](https://private.xtrp.io/projects/DailyDeveloperJokes/public_image_server/images/5e1259582acfe.png)

---
*Have a joke idea for a future post? Email ___[xtrp@xtrp.io](mailto:xtrp@xtrp.io)___ with your suggestions!*

*This joke comes from [Dad-Jokes GitHub Repo by Wes Bos](https://github.com/wesbos/dad-jokes) (thank you!), whose owner has given me permission to use this joke with credit.*

<!-- 
Joke text:
___Q:___ Why did the developer have to quit smoking?

___A:___ Because they couldn't afford to pay the new syntax.
 -->
How to Clear All Formatting of a Range in Excel Office 365?
Tags: kutoolsexceltutorial, stepstoclearallforma, kutools
Published: 2020-10-09 12:10:04

---
title: How to Clear All Formatting of a Range in Excel Office 365?
published: true
date: 2020-10-09 11:55:25 UTC
tags: KutoolsExcelTutorial,StepstoClearAllForma,Kutools
canonical_url: https://geekexcel.com/how-to-clear-all-formatting-of-a-range-in-excel-office-365/
---

In this article, we are going to learn the steps to **Clear All Formatting of a Range in Excel Office 365** using **Kutools.** 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)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Clear All Formatting of a Range:

To clear all formatting of a range, do as follows.

- You need to **select a range** that you want to clear character formatting.

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

- On the **Kutools Tab, select** the **Format** option, **choose** the **Clear Character Formatting** option from the menu.

![select the Clear Character Formatting option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/select-the-Clear-Character-Formatting-option.png)<figcaption id="caption-attachment-15547">select the Clear Character Formatting option</figcaption>

- Now, all the **characters formats** have been **removed** from the selected range as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-24.png)<figcaption id="caption-attachment-15548">Output</figcaption>

## Verdict:

In the above article, you can easily understand the steps to **Clear All Formatting of a Range in Excel Office 365** using **Kutools.** Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Convert Cell Formulas to Text Strings in Excel](https://geekexcel.com/how-to-convert-cell-formulas-to-text-strings-in-excel-office-365/)
- [Insert Title Rows into a Range in Excel](https://geekexcel.com/insert-title-rows-into-a-range-in-excel-office-365-kutools/)
A mini Raspberry Pi for play games
Tags: python, raspberrypi, computerscience
Published: 2020-10-09 11:45:38

When I found a 1.54 inch LCD touchscreen with buttons and joystick, I thought it was very difficult to play games in that. That is true. The size of that screen is more or less like an applewatch. But the advantage is you can connect directly in a lot of monitors and TV to play. I put the screen in a raspberry pi A+ and in a Zero wh. For use like a computer, is better with the A+, but for playing games, I could not find differences bettween them. I decided Use the raspberry pi zero with the screen for playing games and for "make" a computer, the A+ for add the SenseHat and a battery.
I know In the last two pictures is not exactly the same device, but in both of them are a raspberry pi zero wh.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/gokt0brq2mbyc716eamq.jpg)
Best ClickBait Post Titles?
Tags: watercooler, javascript
Published: 2020-10-09 11:43:29

The JS community and really the internet, in general, is prone to 'clickbait' titles.

Many of them try to insult you as a dev - _15 Reasons Why Ur Bad at JS (and how to fix them)_ for example. 

The psychology of attacking everyone's 'imposter syndrome' combined with the prospect of 'fixing it' 😋.

One of my personal favorites of all time was a video 📹 by Brandon Wirtz, published around 2012 when Node first came out: _Node.JS is Stupid and If You Use It, So Are You._

I think 🤔 it's meant to be satirical, I'm not 💯 sure. It's hilarious, and I've been stupid for some years now! 😼

{% youtube 1e1zzna-dNw %}

Anyway, **what are some of your favorite JS clickbait titles, real or imaginary?** No need to actually publish links and give these clickbait-ers any bites - unless it's really funny, or even 'extra' negative - I just like to read them.
Can you use class components with Apollo client 3?
Published: 2020-10-09 11:40:36

Hello great people... I recently started on with apollo v3, been using react-apollo for long and recently was forced to adopt v3. However, I have gonw through the docs and don't see an instance for use with class components. Ofcos we can't use hooks with class components and although `useQuery` and `useMutation` hooks are not specific to react, we can't still use them because they start with keyword `use`. Anyone please give insight about this. thanks in advance
Interactive profile card
Tags: codepen
Published: 2020-10-09 11:25:16

<p>This one is created with Material Design guides in mind, but I wanted to make something more than usual Material Design cliche. So, I made it look like it's out of glass instead of paper. And it's draggable, drag it around to check the background blur effect. Then, make sure to click on the info icon to check the card animation.</p>

{% codepen https://codepen.io/Masquetina/pen/dYYxeM %}
TCL - Week 1
Tags: tcl, webdev, beginners, 100daysofcode
Published: 2020-10-09 11:19:18

For those who do not know: [TCL or The Collab Lab](https://twitter.com/_collab_lab) is a nonprofit that aims to help new developers gain practical experience by working remotely on real-world projects with other early-career developers.

That's what their [website](https://the-collab-lab.codes/) says.

However, what their website does not explicitly say is that they are one of the most welcoming and helpful communities that any new developer would be so lucky to be part of.

When I applied to join them, they did not care that English was not my first language. They did not care that sometimes working with Git and GitHub felt like reading Latin to me. All they cared about was that I applied and that I sounded passionate when I did it.

**What I like most about TCL** so far is that they make you feel that you deserve a chance to be part of this tech world. That you deserve a chance even if you are not the smartest person in the room. That you deserve a chance even if you do not have those shiny, magical years of experience pinned on your wall. That you deserve a chance even if you come from this tiny, little place that would require a lot of zooming in on Google Maps for you to find.

It has been only a week since I have started my journey with TCL. However, on the first day of joining them, I felt the sense of having a team, a task to finish, or an issue to resolve. Besides, the realization that I now have *four* mentors whom I could ask for help whenever I need it is just crazy.