teleren/devto huggingface dataset:
I Published a New Project named ShortApp
Tags: sideprojects
Published: 2020-10-17 07:46:06

Hi everyone!

**Project Site:** [https://shortapp.link](https://www.shortapp.link/)

**Status:** Published, but I believe there should be bugs. In case you see an error, please let me know. I'll also change the homepage design later :)

I made a simple project as a weekend project. In this project, you can redirect to more than one platform over a single link.

For Example, you have iOS, Android apps. These are the same apps. You can normally share both links. But with this application, you can redirect to the application link according to the device at a time.

You can also share a QR code for your single link.

## Example URL (Dev Community)

[shortapp.link/qjHJZ](https://shortapp.link/qjHJZ)

## Example QR Code (Dev Community)

![Dev Community](https://dev-to-uploads.s3.amazonaws.com/i/uwtlz0zr7r1inybofhn2.png)

Thanks <3
Công ty tnhh tavaco
Tags: tavacovn
Published: 2020-10-17 07:45:12

Sơn Tavaco chuyên về sơn nước Dulux, Sơn Jotun, Sơn Maxilite, Sơn Nippon, Bột trét tường Tavaco..
https://tavaco.vn/wiki/acb-online-huong-dan-dang-ky-acb-online-swift-code-acb.html
kong api gateways with docker
Tags: docker, api, microservices, kong
Published: 2020-10-17 07:44:40

[KONG](https://konghq.com/) is a api gateway placed above the microservices aimed to managing the APIs and interactions external and internal with them in a more rational, efficient, safe and "easy" way, helping the developer in the separation between public and private APIs, improving their performance , facilitating monitoring etc ...

### Some Characteristic:
- Built on NGINX
- For the most part written in LUA
- Expandable via many Plugins
- It supports two types of Datastores, which can also be used simultaneously (Postgres, cassandra)

### Advantages:
- Easy management of APIs in a Microservice architecture
- helps in the separation between Public and Private APIs
- allows to measure and possibly limit the use of these APIs.
- Improves performance / through the use of caching etc ...)
- Expandable through many plugins

The best way for move the fists step with KONG is using docker:

first, create and internal network for the dockers:
```
docker network create kong-net
```
create a container for cassandra db:
```
docker run -d --name kong-cassandra-database \
              --network=kong-net \
              -p 9042:9042 \
              cassandra:3
```

create a postgre sql container:
```
docker run -d --name kong-postgres-database \
              --network=kong-net \
              -p 5432:5432 \
              -e "POSTGRES_USER=kong" \
              -e "POSTGRES_DB=kong" \
              postgres:9.6
```

create a migration:
```
docker run --rm \
    --network=kong-net \
    -e "KONG_DATABASE=postgres" \
    -e "KONG_PG_HOST=kong-postgres-database" \
    -e "KONG_CASSANDRA_CONTACT_POINTS=kong-postgres-database" \
    kong:latest kong migrations up
```

create a kong container connected to the postgres and cassandra databases throught the internal network kong-net:
```
docker run -d --name kong \
    --network=kong-net \
    -e "KONG_DATABASE=postgres" \
    -e "KONG_PG_HOST=kong-postgres-database" \
    -e "KONG_CASSANDRA_CONTACT_POINTS=kong-cassandra-database" \
    -e "KONG_PROXY_ACCESS_LOG=/dev/stdout" \
    -e "KONG_ADMIN_ACCESS_LOG=/dev/stdout" \
    -e "KONG_PROXY_ERROR_LOG=/dev/stderr" \
    -e "KONG_ADMIN_ERROR_LOG=/dev/stderr" \
    -e "KONG_ADMIN_LISTEN=0.0.0.0:8001, 0.0.0.0:8444 ssl" \
    -p 8000:8000 \
    -p 8443:8443 \
    -p 8001:8001 \
    -p 8444:8444 \
    kong:latest
  ```

check on url http://localhost:8001/

For more info, go on official web site [here](https://konghq.com/)

<iframe width="560" height="315" src="https://www.youtube.com/embed/wK0obqAFut0" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>
Hacktober Fest
Tags: hacktoberfest, python, computerscience, career
Published: 2020-10-17 07:43:42

## What I Learned From Hacktoberfest

It's really amazing experience. you have to remember that if you are an open-source contributor you must work on the critical sections that help people lighten their work more. It also deals with the benefit of one inner self too. This hacktober help me to contribute libraries like Pandas which help in ML develops and data scientists to work over datasets. I am really happy that my work now helps people around the globe. I also contribute one advanced algorithm library which contains all the algorithms. remember "you are not alone in this world of tech there is someone who holds you not make you fall down" It's up to you how you see that help.
Do Remember thing
1. Contribute to the robust project is ok but contributing to a project which has more issues to make your work more and stretch your limits.
2. Try to resolve issues in code. Contributing to documentation and MarkDown files is not that much help you to be a developer.
3. If you are a developer try to implement things and make them useful for others.

want any help : 
GitHub : [Anubhav Sharma](www.github.com/anubhavsharma430)
Linkedin : [Anubhav Sharma](www.linkedin.com/in/anubhav-sharma-as)
Mail Id : [Anubhav Sharma](mailto:anubhavsharma9199@gmail.com)
Completing Hacktober Fest...
Tags: hacktoberfest
Published: 2020-10-17 07:39:43

Being a Sophomore Hacktober Fest had introduced me to a world of Open Sourcing...

I had developed a Todo List using Node.js, I had learnt many new technologies and made sure that I was able to complete 1 project end to end. I would like to thank Digital Ocean for taking up such an amazing initiative!! #hacktoberfest @DigitalOcean.
Formula to Vlookup Values from Right & Returns to Left Column in Excel!!
Tags: excelformula, excelformulas
Published: 2020-10-17 07:34:17

---
title: Formula to Vlookup Values from Right & Returns to Left Column in Excel!!
published: true
date: 2020-10-17 07:33:29 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formula-to-vlookup-values-from-right-returns-to-left-column/
---

## Formula to Vlookup Values from Right and Return Results in the Left Column in Excel:

In this short tutorial, we will explain the details about **Formula to Vlookup Values from Right and Return Results in the Left Column 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)

## Formula Syntax:

- Here we will show the formulas to Vlookup Values from Right to Left Column.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)([Sheet](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/)1!F2,[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)({1,0},Sheet1!$D$2:$D$6,Sheet1!$A$2:$A$6),2,0)**

### Example:

- For example, we will show how to apply the formulas to Vlookup values from Right and Returns to Left Column.
- We will enter the inputs in **Column A** , **Column B** , **Column C** , and **Column D**.
- After that, enter the formula in the selected area as shown below.
- Finally, we will get the results in the selected **Column G**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/gh4.png)

## Syntax Explanation:

- **VLOOKUP ** – In Excel, the [**VLOOKUP function**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/) is used to look up data in a range or table by row. It also supports an exact match, an approximate match, and wildcards for partial matches.
- **IF** – It will return one value for a TRUE result, and another one for a FALSE result. Read more on [**IF Function.**](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)
- **Sheet** – The main purpose of the [**Sheet Function**](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/) is to return the index number of a reference sheet in the Excel Office. It helps to find the index number of any sheet in the workbook.

## Verdict:

In this article, you can get to know the **Formulas to Vlookup Values from Right and Return the Result in Left Column in Excel 365**. If you have any **queries,** share it in the below **comment** box. Thank You for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**

### Read Also:

- 

**[Formulas to Find the Date & Time Calculations in Excel 365!!](https://geekexcel.com/formulas-to-find-the-date-time-calculations-in-excel-365/)**

- 

**[How to Round Cell Values without Formulas in Excel Office 365?](https://geekexcel.com/how-to-round-cell-values-without-formulas-in-excel-office-365/)**
Formulas to LOOKUP & SUM the 1st or Matched Values in Row or Column
Tags: excelformula, excelformulas
Published: 2020-10-17 07:34:24

---
title: Formulas to LOOKUP & SUM the 1st or Matched Values in Row or Column
published: true
date: 2020-10-17 07:31:39 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-lookup-sum-the-1st-or-matched-values-in-row-or-column/
---

## Excel Formulas to LOOKUP and SUM the First or All Matched Values in Rows or Columns:

This page will explain the detailed information on how to use the **Formulas to LOOKUP and SUM the First or All Matched Values in Rows or Columns** 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)
## Formula Syntax:

- In Excel, the following Formula is used to  LOOKUP and SUM the First or All Matched Values.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(([Sheet](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/)2!$B$1:$F$1=Sheet2!B11)\*Sheet2!$B$2:$F$8)**

### Example:

- In the below screenshot, we give the input range in **Column A** to **Column F**.
- Then, enter the given formula in the selected field.
- After applying the formula, it will display the output as shown below.

![Lookup and sum all matching values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/gh12.png)

## Syntax Explanations:

- **SUMPRODUCT** – In Excel, the [**SUMPRODUCT Function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/) will multiply the corresponding arrays or ranges and displays the sum of the product as result.
- **Sheet** – This function is used to return the index number of the sheet. Read more on [**Sheet Function**](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/).

## Closure:

From this article, you can easily understand the **Formula to LOOKUP and SUM the First or All Matched Values in a Rows or Column** in Excel Office 365. Share your valuable **feedback** in the below comment box. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**
Situs Slot Online Terpercaya
Tags: slotjoker123, slotkingkong123, slotace333, slotnaga
Published: 2020-10-17 07:28:25

situs slot online terpercaya memberikan pelayanan 24 jam penuh, Dan memberikan bonus new member 50%.
Menangkan jutaan s/d ratusan juta rupiah. Dan jangan menunggu lama untuk mendapatkan keuntungan yang besar !!!
<a href="https://majalahslot.xyz/2020/06/" rel="nofollow">situs slot online terpercaya</a><br>
Completed Hacktoberfest Challenge2020
Tags: hacktoberfest
Published: 2020-10-17 07:26:22

This was my first HacktoberFest and I learned a lot by contributing as a beginner. I would like to thank DigitalOcean, Github, and DEV Community for organizing this open-source event which gives beginners a great platform to showcase their skills. The experience was very amazing and I enjoyed it a lot!
Hacktoberfest Experience
Tags: hacktoberfest
Published: 2020-10-17 07:24:42

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

### What I Learned From Hacktoberfest

I learn how to contribute in open source doing fork repository, make a pull request and fix / open an issue in some project. There is so many project and so many issues with hacktoberfest topic in github to help beginner practice how to contribute in open source. I think hacktoberfest is event where global developers across the world can help each other for make a better world with open source projects.

<!-- What did you learn that can help others contribute to the project you worked on? What did you learn that can help the users of that project?! -->
HACKTOBER FEST 2020
Tags: hacktoberfest
Published: 2020-10-17 07:20:44

## What I Learned From Hacktoberfest
In the beginning i am not so aware about opensource but after this great event i was able to submit more than 4 pull requests as well as learn how to create issues solve issues make a pull request and also how to create and edit a beautiful file generally known as readme.md using markdown for my repositories

The 4 projects for which i completed this ,i will only share about them.
1)A cancer type predicting model using Artificial neural network 
repo link:-https://github.com/Ashishkumarpanda/Cancer-Type-detection
2)i have started with a basic hello world program using python programming language
repo link:-https://github.com/Ashishkumarpanda/Hello-World
3)I have worked on some cool projects like creating a pencil sketch of a provided image using opencv and python.In which it will be helpful if anyone give some suggestions.
repo link:-https://github.com/Ashishkumarpanda/Photo-Sketch-maker
4)After gaining some experience i have contributed to Devincepts deep learning repository and i was very much happy when recieved the mail that the pr was merged from them.
repo link:-https://github.com/Ashishkumarpanda/Contribution-program

so that's all about my first hacktoberfest experience.
happy coding:)
Hacktoberfest 2020
Tags: hacktoberfest
Published: 2020-10-17 07:14:20

Completed the Hacktoberfest 2020 successfully! Prior to this I felt it was very hard to do Open-source contributions and you need to be a professional coder to do it. But now I can say that you don't need to be professional to do open-source. It was a great learning experience for me!

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

## What I Learned From Hacktoberfest

1. How Open-Source works and what significance it has.
2. How git and github helps in open-source.
3. Every contribution is important - be it small or big.

I am going to continue doing Open-Source and increase my learnings even more!
Set Row Height or Column Width in Inches/Pounds/Centimeters/Pixels!!
Tags: kutoolsexceltutorial, setrowheightorcolumn, kutools
Published: 2020-10-17 07:30:23

---
title: Set Row Height or Column Width in Inches/Pounds/Centimeters/Pixels!!
published: true
date: 2020-10-17 07:14:00 UTC
tags: KutoolsExcelTutorial,SetRowHeightorColumn,Kutools
canonical_url: https://geekexcel.com/set-row-height-or-column-width-in-inches-pounds-centimeters-pixels/
---

In this post, you will learn the steps to **Set Row Height or Column Width in Inches/Pounds/Centimeters/Pixels** 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.

## Steps to Adjust Row Height or Column Width in Excel:

- First, you need to **select the range** that you want to adjust the cell size.

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

- On the **Kutools Tab, select** the **Format** option, **choose** the **Adjust Cell Size** option from the menu.

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

- It will open the **Adjust Cell Size Dialog box**.
- In that dialog box, you need to **select** the **Unit type (Pound, Centimeters, Inches,** and **Pixels)** that you need under the **Unit type section**.
- Then, you need to **check** the **Row height** and **Column width** option under the **Set values** section.
- After that, **specify them** using the given **drop-down list**.

![Adjust Cell Size Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/EXCEL_fIBJ9UN67a.png)<figcaption id="caption-attachment-15953">Adjust Cell Size Dialog box</figcaption>

- Finally, **click** the **OK** button to see the result.

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

At last, the row height & column width changes to a specified centimeter.

## Summary:

In this post, you can learn the steps to **Set Row Height or Column Width in Inches/Pounds/Centimeters/Pixels** in **Excel Office 365** using **Kutools.** Leave your **feedback** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Change Date Format in Excel Office 365](https://geekexcel.com/how-to-change-date-format-in-excel-office-365-simple-ways/)
- [Convert or Spell Out a Number into English Words in Excel ](https://geekexcel.com/convert-or-spell-out-a-number-into-english-words-in-excel-office-365/)
My Hacktoberfest Experience
Tags: hacktoberfest
Published: 2020-10-17 07:13:38

I came to know about DEV community from Hactoberfest, therfore I am dedicating my first post here to my personal experience with Hacktoberfest.

## Background
Before, I tell you about my experience I would like to say I am a complete newbie. 
Before, this fest I have no experience in any such even. Earlier I used to think that you need to be an expert to contribute to such events which clearly is not true in this case.

I have little experience in competitive programming an the languages I have ever worked on are C, C++, Python , R, HTML with certain degree of understanding in MySQL database.

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

## What I Learned From Hacktoberfest
Hacktoberfest has been amazing for me I learnt a lot from it. For the first time I worked in an actual team of like minded people to build GitHub repositories.

Apart from this wonderful experience of working with people from all over the world I also learnt a lot about GitHub such as pull request, solving merge conflicts, for the first time I used issues in a GitHub repository.

Overall I would say a great experience for me enjoyed every bit of it and looking forward to continue with more enthusiasm.
I finished Hacktoberfest!
Tags: hacktoberfest
Published: 2020-10-17 07:11:55

---
title: I finished Hacktoberfest!
published: true
description: 
tags: hacktoberfest
//cover_image: https://direct_url_to_image.jpg
---

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

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

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

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

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/a3bvkgftwfn1x8wol5ww.png)
Hacktoberfest 2020
Tags: hacktoberfest
Published: 2020-10-17 07:09:52

## What I Learned From Hacktoberfest
Because of hacktoberfest got an exposure to the GitHub 
environment and learned to make a pull request and other actions 
in the GitHub.

<!-- What did you learn that can help others contribute to the project you worked on? What did you learn that can help the users of that project?! -->
I am willing to accept others who can make changes to my source code that can make the code looks cleaner and simpler rather than complex.
The user authentication deserve more attention
Tags: security, authentication, digitaltransformation
Published: 2020-10-17 07:05:25

he user authentication deserves more attention. There is no more space for self-made solutions.

In 2020 we cannot reinvent the wheel but just push the digital transformation.

Why? I'm tired of custom authentication solutions. 

I hate the friction we feel while accessing to the ecosystem of tools that we use daily. 

**I’m myself, why I should prove it two times?**

Moreover, with the upcoming security threat, I’m also curious about where I’m typing my passwords—security matters for me.
I remember the first timid attempts at creating SSO (Single Sign-On) solutions in the 2000s. 

We had many handcrafted tools, using cookies, redirect, and other tricks for getting the job complete. Every company had to reinvent the wheel.

This age ended when OAuth (and then OAuth2) become the standard and helps to create SSO scenarios and authentication sharing with ease.

Well, this was a big step forward, but it is not the end. The Oauth2 protocol solves only one part of the problem: we still need to code for implementing the authentication system.

Coding is wonderful but requires time and costs. We cannot reinvent the wheel each time. 

That’s why I wrote an article about finding a standard solution for identity access management (IAM) — and you should read it!

[In this article, I explain the pain points about authentication and how to solve them by adopting a standard solution](https://towardsdatascience.com/the-user-authentication-deserve-more-attention-d3cb861956d2?source=friends_link&sk=920670e81cfe947f1eb1e99b4d99ed2d)
[Hacktoberfest] On my way to Open Source Career
Tags: hacktoberfest
Published: 2020-10-17 07:05:07


<p> I graduated as a Computer Engineer on September 2020. Yeah well, that's just for a name sake. What did I learn this 4 years ? Nothing ! Absolutely nothing ! Am I going for a negative, bad vibe story ? Not really. </p>

<p>It was during the month of March 2020 when the prime minister declared lockdown. I realized that, until now I was just wasting my time, while my peers was learning something new and achieving on their way. What to do now ? I scrolled down through a lot of posts from my peers in LinkedIn and they have achieved almost everything that I have only started to dream of. OK ! They are ahead of me. No, I am really lagging behind. There is a huge gap between us. How am I suppose to shrink that. I should give up. Then again, now I am having a lot of free time. I can compensate the time I have wasted (** cough 4 years **) </p>

<p>Complaining is not an option. I am not competing with anyone but me, the old me ! I started learning and made up my mind to keep a GitHub daily streak. It was hard at first though. </p>
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/d8pb44bb7nsw661p6e1j.png)
<p>I started joining hackathons. At first, it was all about swags ! I wanted to collect them. That's when I heard about Hacktoberfest ! More swags (lol) </p>


<p>Hacktoberfest started of pretty well. But, I didn't knew what to contribute to. I realized that, it is harder than I thought. I have to learn if I want to contribute. Yeah, I have to learn (I am trapped). It was a slow process but, worth it. I started contributing. I forgot about the swags. As a starter, I was scared (and ashamed) to ask to anyone about my doubts. But, this community is really (really x million times) welcoming. They are the best. I am so happy to be a part of it now. A family. </p>
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/9s88y4f4hynb2dfskr8f.png)


<p> I admit it.... I am in love with Open Source now (blame is on Hacktoberfest). I am thinking about pursuing my career on the same. I am just a beginner and have a long way to go. But, I will surely contribute</p>
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/t8gwo7zpow9iuk39ykb6.png)

### A big thanks to Hacktoberfest and the whole community.