teleren/devto huggingface dataset:
Equipping yourself with Excel increase job opportunities
Tags: datascience, database, microsoft
Published: 2023-11-17 16:51:15

In today's world, having tech skills is crucial for success and increasing job opportunities. Learning a software skill in the 21st century is valuable, and one such skill is Microsoft Excel.

Over the past few months, I have been exploring the capacity and features of Excel, and it has been an eye-opener. Excel is the most popular and widely used spreadsheet application in the industry. It is used for organizing, analyzing, and visualizing data, as well as for advanced calculations with its functions and formulas, and graphical representations.

Due to its effectiveness and features, Excel is used in almost every industry. Having advanced knowledge in Excel can make you stand out and open up job opportunities in data analysis, data science, data engineering, business intelligence analysis, accounting, database management/administration, and more. While other skills are necessary, Excel is a fundamental skill for working in these professions.

Adding Excel as a skill on your CV can give you an edge and increase your potential as a prospective employee. It allows you to carry out administrative duties, create data reports, manage projects and budgets, and collect, organize, and analyze data for decision-making.

It's important to recognize that Excel is more than just a Microsoft application that comes with your system or office application package. Learning and using Excel is just as important as any other Microsoft Office application. Fortunately, access to tutorials is easy to find online, on platforms like YouTube or e-learning websites.

Learning Excel doesn't have to be difficult; you can self-tutor yourself. I have found https://excel-practice-online.com to be a very effective platform for learning. You can practice alongside your learning.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/v0kfmlvy203irab7g5fe.jpeg)

Taking a step with Excel can improve your job hunting opportunities and your potential as an effective employee. Whether you want to add an advanced skill to yourself or become a data analyst or data scientist, Excel and other spreadsheet applications are valuable tools that you can use.
some() in javascript
Tags: webdev, react, javascript, node
Published: 2023-11-17 16:48:17

what is **`some()`** method in javascript with help of 2 example

**EXAMPLE 1**
we need to check if an array contain **`admin`** role, then only we need to give access to some resources in our application

simple stupid way is to use **`some()`** method in javascript

{% embed https://gist.github.com/RaisanJMR/4dc46733033627bf4f1ba6af61046fbb.js %}

**EXAMPLE 2**

Here we have an array that has students' marks out of 20. and pass mark is 9, We need to check if all students have passed or not.if at least one student fails **`some()`** method returns **`false`**
{% embed https://gist.github.com/RaisanJMR/2e0a7411d623432dc185870397ee3785.js  %}

**EXAMPLE 3**

consider we have an array of objects representing food items, and you want to check if at least one food item belong to a specific category such as 'Fruit'
{% embed https://gist.github.com/RaisanJMR/edc8017e7898643c55822fcb72b61059.js %}
❤️have a nice day❤️
Placeholder Contributor
Tags: hack23contributor
Published: 2023-11-17 16:45:57

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

<!-- Share a bit about yourself as a contributor. Is this your first Hacktoberfest, or have you contributed to others? Feel free to embed your GitHub account by using {% embed LINK %} -->

Hello Geeks I am Aditya Singh, currently in second year at IIIT Ranchi. This was my first Hacktoberfest and I am very delighted to share with you all that it was fun participating in the event.


<!-- What were some of your biggest accomplishments or light-bulb moments this month? Did any problems come up that seemed impossible to fix? How did you adapt in those cases?  -->

Some times the pull requests were not mereged and sometimes other problems came but as we all know consistency is the key so I kept on it and finally succeeded.


<!-- What was your skillset before Hacktoberfest 2023 and how did it improve? Have your learning or career goals changed since working on these new projects? -->
Learning things and implying your learning are two completely different things. On this note I would like to say that implementing my knowledge was also a challenge for me but having successfully done that makes me happier than ever.
Hire Top-Notch App Developers Today!
Published: 2023-11-17 16:42:52

**TechnBrains: Your Source for [Expert Developers](https://www.technbrains.com/services/hire-developer/) & Designers!**

• Find top talent globally for your projects.
• Hire experienced web developers, freelance designers, and app 
  developers.
• Bridge the industry-talent gap with effective measures.
• Instant solutions for specific requirements worldwide.
  Why Choose Professionals?
• Experienced developers offer streamlined solutions and growth.

**Explore Our Talent Pool**

• Hire Expert Designer: Creative experts for web, mobile, 
  and branding.
• Hire WordPress, PHP, Magento, Shopify Developers: Quick 
  and functional solutions.
• Hire Mobile App Developers: Find the right professional.

**Talk to us for a customized solution. Connect with TechnBrains today!**
Day 90: Indexdb
Tags: webdev, frontend, 100daysofcode, html
Published: 2023-11-17 16:30:00

## What is IndexedDB?
IndexedDB is a low-level API for client-side storage of significant amounts of structured data, including files/blobs. It provides a way for developers to create, read, navigate, and write to a user's local database. IndexedDB is especially useful for applications that require offline capabilities, allowing users to interact with data even when an internet connection is unavailable.

### Setting Up with Dexie

To make our journey with IndexedDB smoother, we'll leverage Dexie, a minimalistic IndexedDB wrapper. Let's start by installing it:

```bash
npm install dexie
```

Now, let's dive into the code:

```javascript
// Import Dexie
import Dexie from 'dexie';

// Create a new database
const db = new Dexie('MyDatabase');

// Define a table
db.version(1).stores({
  friends: '++id,name,age',
});

// Open the database
db.open();
```

This simple setup with Dexie creates a database named 'MyDatabase' with a table called 'friends,' each having an auto-incremented ID, name, and age.

## Basic Operations

### Add

```javascript
const friend = { name: 'John Doe', age: 25 };

// Add a friend to the 'friends' table
db.friends.add(friend)
  .then(id => console.log(`Added friend with ID ${id}`))
  .catch(error => console.error(`Error adding friend: ${error}`));
```

### Query

```javascript
// Retrieve all friends with age greater than 21
db.friends.where('age').above(21).toArray()
  .then(friends => console.log('Friends above 21:', friends))
  .catch(error => console.error(`Error querying friends: ${error}`));
```

### Update

```javascript
// Update John Doe's age to 26
db.friends.where('name').equals('John Doe').modify({ age: 26 })
  .then(updated => console.log(`Updated ${updated} record(s)`))
  .catch(error => console.error(`Error updating friends: ${error}`));
```

### Delete

```javascript
// Delete a friend by ID
const friendIdToDelete = 1;
db.friends.delete(friendIdToDelete)
  .then(() => console.log(`Deleted friend with ID ${friendIdToDelete}`))
  .catch(error => console.error(`Error deleting friend: ${error}`));
```

## Tips 

1. **Use Transactions Wisely:**
   When performing multiple operations, group them within a transaction to ensure consistency.

   ```javascript
   db.transaction('rw', db.friends, async () => {
     // Multiple operations
   });
   ```

2. **Optimize for Performance:**
   Avoid reading or writing to the database excessively. Optimize queries and use indexes for faster retrieval.

3. **Error Handling:**
   Always handle errors to provide a better user experience and aid debugging during development.

## Usage

1. **Progressive Web Apps (PWAs):**
   Enable offline functionality by storing data locally for seamless user experiences.

2. **Caching:**
   Store static assets like images, styles, and scripts to reduce server requests and improve load times.

3. **Data-Intensive Applications:**
   Handle large datasets efficiently, such as in data visualization or analytics tools.

4. **Form Data Persistence:**
   Save user input locally to prevent data loss in case of accidental page reloads.
토토사이트추천! Pong Bet - 다양한 혜택과 다채로운 게임으로 여러분을 초대합니다!
Published: 2023-11-17 16:29:11


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cod925b3yb6l46uun513.jpg)
입플 이벤트 진행 중!

 신규가입시 첫충건 40%, 매충전 15% 이벤트로 여러분을 환영합니다!
 다채로운 이벤트로 더 즐겁게 즐기세요!

 투타임 이벤트: 특정 시간대에 배팅하면 더 큰 혜택이 여러분을 기다립니다!
 리베이트 이벤트: 손실금액의 일부를 현금 또는 보너스로 환급받을 수 있는 리베이트 이벤트가 진행 중입니다!
 두끼 이벤트: 배팅이 맛있게! 특별 보너스로 게임을 더욱 풍성하게 즐기세요!
 다양한 배팅종목으로 즐거운 시간을 보내세요!

 스포츠 및 라이브스포츠: 현장감 넘치는 스포츠와 라이브스포츠로 즐거운 시간을 보장합니다.
 카지노 및 슬롯머신: 10가지 이상의 다양한 카지노 게임과 2000가지 이상의 슬롯머신이 여러분을 기다립니다.
 미니게임, 토큰게임, 지뢰찾기: 다양한 미니게임과 독특한 토큰게임으로 여러분의 선택을 기다립니다!
 찾아가기: pong-aa.com
 가입코드: A T

 토토사이트추천 Pong Bet으로 특별한 혜택과 다채로운 게임을 경험하세요! 여러분의 행운이 가득할 것입니다. 지금 바로 참여해보세요! 


1번주소 -> http://pong79.com/			
퐁벳평생주소 : -> http://퐁주소.com/			
가입코드 : A T			
 			
			
❤️ 국내,해외 스포츠 분석 보러가기!			
☑️ 네이버 -> https://cafe.naver.com/browncqpaq			
☑️ 네이버카페 "AI DataBase" 검색			
☑️ 더 많은 입플 이벤트 진행사이트 확인 -> http://입플사이트추천.com			
❤️메이저 토토사이트 -> https://start.me/p/OmrOQ0			
❤️메이저 안전놀이터 -> https://start.me/p/lLg592	
❤️검증사이트 -> https://www.mtmt114.com	



![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/pl489dz90c6kw67xcb6b.jpg)
Navbar
Tags: codepen, navbar, vinkal041, vinkal
Published: 2023-11-17 16:08:05

Check out this Pen I made!

{% codepen https://codepen.io/vinkalPrajapati/pen/QWYaqXM %}

The provided HTML code includes a navigation overlay controlled by a button. Here's an explanation of the code:

1. **Navigation Overlay (`#myNav`):**
   - The navigation overlay is a `<div>` element with the ID `myNav`. It's initially hidden (`height: 0;`) and becomes visible when the `openNav()` function is triggered.

2. **Close Button (`&times;`):**
   - The close button within the overlay has the class `closebtn` and triggers the `closeNav()` function when clicked. It displays an '×' symbol.

3. **Overlay Content:**
   - The overlay contains a list of links (`<a>`) representing navigation items such as "About," "Services," "Clients," "Contact," and "About Vinkal Prajapati."

4. **Button (`<button>`):**
   - The button with the class `font` triggers the `openNav()` function when clicked. It displays the Unicode symbol "&#9776;" (three horizontal lines), commonly recognized as a menu icon.

5. **JavaScript Functions:**
   - The `openNav()` function sets the height of the overlay to "80%", making it visible.
   - The `closeNav()` function sets the height of the overlay to "0%", hiding it.

6. **Styling (`<style>`):**
   - The styling section contains CSS rules for the button (`font` class). It sets the font size to 30 pixels, changes the cursor to a pointer, and centers the button horizontally within its container.

   ```css
   .font {
     font-size: 30px;
     cursor: pointer;
     display: block;
     margin: 0 auto;
   }
   ```

   The `display: block;` and `margin: 0 auto;` combination is used to center the button horizontally.

This code creates a simple navigation overlay that appears when the button is clicked, providing a clean and user-friendly interface for accessing various sections of the website.
Productivity Tips
Tags: vscode, shortcuts
Published: 2023-11-17 15:46:31

Keyboard shortcuts in this post:

1. [Switch between apps](#switch-between-apps)
2. [Change multiple lines of code](#change-multiple-lines-of-code)

---

## Switch between apps

Keybinding: 
- Mac - `CMD + TAB`
- Windows - `ALT + TAB`

![Gif showing the CMD + ALT keybind in action](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rvuyrxh7rownq5srehkh.gif)

To switch between open apps:
- Hold `CMD` / `ALT`
- Press `TAB` as many times until you get to the app you want to switch to
- Release `CMD`

The two most recent apps will always be first in the list

Once you've got the two apps you want to switch between at the start:
- Quickly `CMD + TAB` and let go

---

## Change multiple lines of code

Keybinding: 
- Mac - `CMD + D`
- Windows - `CTRL + D`

![Gif showing the CMD + D keybind in action](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wnhw3se1m2u3y13jt3hl.gif)

To select multiple occurrences of some text:
- Highlight the first instance of that text
- Hold `CMD` and press `D` to add the next occurrence to your selection
- Press `D` as many times as there are occurrences
- Let go of `CMD` and start typing / using your arrow keys
A Startup's Journey from Hackathon Victory to Global Recognition - The Get A Buddy Story
Tags: coding, webdev, career, startup
Published: 2023-11-17 15:44:36

Greetings !

 Today, I'm thrilled to share a memory and a remarkable journey that began with a hackathon victory and has now evolved into the growth of our startup, 'Get A Buddy.'

In the fast-paced world of tech innovation, our journey started at the Hackathon Citizens of Wallonia in Charleroi. With only three months into our studies at BeCode, an institution dedicated to empowering individuals with web development skills, my colleagues, Laurent Eyckermans, Raphael Haasper and I decided to dive into this intense 48-hour competition. Little did we know, this experience would become the catalyst for something extraordinary.

Driven by the passion to make a difference, we conceptualized a project during the hackathon that surpassed our own expectations. Our idea? A web app designed to be a city guide for newcomers, providing essential information about everything from shopping spots to securing safe transportation. What made our project unique was the integration of a buddy' system : volunteers ready to assist newcomers in navigating their new city, just as Raphael needed when he first arrived in Brussels from Brazil.


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/d8vfo0i1o4azp2pi1xoy.jpg)

Despite the sleepless nights and the formidable competition, our project earned us the grand prize, propelling us to the Smart City Expo World Congress in Barcelona in 2023. This victory was not just a celebration of our hackathon success but also marked the beginning of Get A Buddy's journey towards making a meaningful impact.

Reflecting on this journey, we realized the power of collaboration, innovation, and the impact of technology on creating solutions that genuinely matter. It's not just about winning a hackathon; it's about turning that victory into a project that addresses real-world challenges and connects people in a meaningful way.


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8dhlon6a7gzf7sh00smi.jpg)

In every city, integration is a unique code. We believe it's the local buddy who decodes the nuances, making your city visits and life in a new place not just informative but enjoyable. Get A Buddy is more than information sharing; it's about becoming an integral part of your new city. Join us on this transformative journey, where we're here to seamlessly help you integrate and truly thrive in your new home!

As we journey with Get A Buddy, the memories of our career shifts, BeCode experience, and triumphant hackathon victory remain vivid. From these roots, we've grown, forged wonderful connections, and birthed a startup with a vision—to positively change the world, one city at a time. Stay tuned and watch us grow on [Instagram](https://www.instagram.com/getabuddy_/?hl=fr).

Anthony
Sidebar always shown.
Tags: codepen, sidebar, vinkal041, vinkalprajapati
Published: 2023-11-17 15:43:05

Check out this Pen I made!

{% codepen https://codepen.io/vinkalPrajapati/pen/JjxMroL %}

Sidebar
This sidebar is of full height (100%) and always shown.

!DOCTYPE html: This declaration specifies the document type and version of HTML being used. In this case, it's HTML5.


html: This tag represents the root of the HTML document.

head: This section contains meta-information about the HTML document, such as the viewport settings and styles.

meta name="viewport" content="width=device-width, initial-scale=1": This meta tag ensures that the web page is displayed correctly on various devices by setting the viewport width to the device width and scaling it to 1.

style: This tag contains the CSS styles for the document.

body: This tag represents the content of the HTML document, and it contains two main sections:

.sidenav: This is a div element with the class "sidenav" representing the sidebar navigation menu. It includes links to different sections of the page.

.main: This is a div element with the class "main" representing the main content area of the page. It has a left margin to accommodate the width of the sidebar.

CSS Styles:

.sidenav: This defines the styles for the sidebar, making it fixed, with a width of 160px, a dark background color, and links with specific styles.

.sidenav a: This defines the styles for the sidebar links, setting the font size, color, and padding.

.sidenav a:hover: This defines the styles for the sidebar links when hovered over, changing the text color.

.main: This sets the margin and font size for the main content area, allowing it to adjust according to the width of the sidebar.

@media screen and (max-height: 450px): This media query adjusts the styles when the screen height is 450px or less. In this case, it reduces the padding and font size of the sidebar links. This is often used for better responsiveness on smaller screens.

In summary, this code provides a basic HTML structure for a webpage with a responsive sidebar navigation menu using CSS styles. The sidebar collapses and adjusts its appearance for smaller screens, ensuring a better user experience on different devices.
🚀 안전보증놀이터 - FLASH BET, 특별한 혜택과 다채로운 게임으로 여러분을 초대합니다! 🎰
Published: 2023-11-17 15:41:43


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/w1f9nxmw8hfvd7y86owc.jpg)

 입플 이벤트 진행 중!

 신규가입 쿠폰이벤트 및 매충전 20% 무한지급 이벤트로 여러분을 환영합니다!
다양한 이벤트로 더 즐거운 게임을 즐기세요!

 매.충전 20% 무한지급: 매 충전 시 20%의 무한지급으로 게임을 더욱 풍성하게 즐겨보세요!
 지인추천 이벤트: 지인을 초대하고 특별한 혜택을 누리세요!
 프리미엄 출석이벤트: 매일 출석으로 특별한 상품을 획득하세요!
 에볼루션,[](url) 플레이텍 카지노 및 카지노슬롯머신 이용 가능!

 미니게임 다수: MGM바카라, 파워볼, bet365 가상게임 등 다양한 미니게임으로 즐거운 시간을 보내세요.
 스포츠 및 라이브배팅: 다양한 스포츠 종목에서 실시간으로 베팅하여 즐거움을 더하세요!

 찾아가기: fla-k1.com
 가입코드: A T

 FLASH BET으로 안전하고 즐거운 게임을 경험하세요! 여러분의 행운이 가득할 것입니다. 지금 바로 참여하세요! 🚀

주소 : -> (http://fla-k1.com)			
코드 : A T			
❤️ 더많은 사진, 영상 보러가기!			
☑️ 네이버 -> (https://cafe.naver.com/browncqpaq)			
☑️ 네이버카페 "AI DataBase" 검색			
☑️ 더 많은 입플 이벤트 진행사이트 확인-> [](http://입플사이트추천.com)			
❤️메이저 토토사이트 -> (https://start.me/p/OmrOQ0)		
❤️메이저 안전놀이터 -> (https://start.me/p/lLg592)
❤️먹.튀검증사이트 -> (https://www.mtmt114.com)	

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5fl2omqay66tw7i83s3a.jpg)
Лечение кариеса в стоматологии в СПБ
Published: 2023-11-17 15:35:19



Кариес зуба – распространенное заболевание, которое требует своевременного лечения. Необходимо обратиться к стоматологу, чтобы избежать возможных осложнений. Кариес может возникнуть у любого человека, независимо от возраста и состояния зубов.    ## Лечение кариеса зуба    

В настоящее время существует множество методов лечения кариеса. Однако, каждый случай требует индивидуального подхода. Врач проводит осмотр и диагностику, после чего определяет наиболее эффективный метод лечения.    ## Профессиональная стоматология в Санкт-Петербурге    

Если вы проживаете в Санкт-Петербурге и ищете качественную стоматологическую помощь, то обратитесь в нашу клинику. У нас работают опытные врачи, которые осуществляют лечение кариеса с использованием современных методов и технологий. Мы гарантируем безболезненность процедур и высокое качество работы.    ## Онлайн-запись на прием    

У нас вы можете записаться на прием онлайн, используя удобную форму на нашем сайте. Это позволяет сэкономить время и быстро получить консультацию специалиста. Наша клиника готова помочь вам вернуть здоровье и красоту вашей улыбки.    ## Ссылки:    <ul>    <li>[Лечение кариеса](https://probolezny.ru/karies-zuba/)</li>    <li>[Стоматология в СПБ](https://kronadent.ru/services/lechenie-kariesa/)</li>  </ul>
C# - Default Interface Methods
Tags: csharp, programming, tutorial, beginners
Published: 2023-11-17 15:30:00

Default interface methods are a feature in C# that allows you to define an implementation for an interface member. This can provide a lot of flexibility, especially when evolving interfaces over time without breaking existing implementations.

For instance, you might have an interface representing a sensor in an IoT application, and over time you want to add a new method to it. Adding a new method to the interface would break all existing implementations. With default interface methods, you can add a new method with a default implementation, and all the existing implementations will continue to work without any modifications.

Here's an example of how to use default interface methods:

```csharp
public interface ISensor
{
    string GetStatus();
    
    // New method with a default implementation
    void Reset()
    {
        Console.WriteLine("Default reset implementation.");
    }
}

public class TemperatureSensor : ISensor
{
    public string GetStatus()
    {
        // Implementation specific to temperature sensor.
        return "TemperatureSensor status";
    }

    // Reset method isn't required to be implemented thanks to the default implementation.
}

public class Program
{
    public static void Main()
    {
        ISensor sensor = new TemperatureSensor();
        Console.WriteLine(sensor.GetStatus()); // Output: TemperatureSensor status
        sensor.Reset(); // Output: Default reset implementation.
    }
}
```

Use default interface methods to add new functionality to interfaces while keeping backward compatibility with classes that were written against earlier versions of the interface. This allows for more flexible and robust API design, particularly in libraries and frameworks.
Custom WP Thumbnail Sizes
Tags: wordpress
Published: 2023-11-17 15:27:12

By default, WordPress creates 5 image files when you upload a featured image (the original plus 4 smaller versions). Adding a custom-sized image for featured images is possible by using the `add_image_size()` function inside your _functions.php_ file.

As an example, let's say you want a 200 x 200 image with the nickname of "my_avatar".

```php
function my_site_features() {
  add_image_size('my_avatar', 200 , 200, true);
}
```

As you can see, the add_image_size() function accepts 4 arguments: the name, width, height, and a boolean value for whether or not you want to crop the image (true=crop, false=no crop).

## Quick side note

To retroactively regenerate "my_avatar"-sized thumbnails for all your existing image uploads, one good option is to use the [Regenerate Thumbnails](https://wordpress.org/plugins/regenerate-thumbnails/) plugin.

As an alternative, you can use [Jetpack's Photon Module](https://jetpack.com/support/site-accelerator/).

## Displaying the "my_avatar"-sized image on a web page

Let's say you want to display that "my_avatar" custom-sized image in your _single-event.php_ template file. All you have to do is add "my_avatar" as an argument for `the_post_thumbnail()`. For example:

```php
the_post_thumbnail("my_avatar");
```