productivity - CybAI news

10 Jul

Group Rows and Concatenate Cell Values

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, programming, software, tutorial

Problem description & analysis: Here is a categorized detail table: We need to group the table and concatenate the detail data using the semicolon. Solution: Use SPL XLL to do this: =spl("=E@b(?.groups(~1;concat(~2;$[;])))",A2:B9) Enter fullscreen mode Exit fullscreen mode As shown in the picture below: Explanation: E@b function converts the two-dimensional table to a sequence. ~1 represents the first sub-member of the current member; and $[] represents a string. Source link lol

09 Jul

Python Decorators: What is decorators and how to use them?

stp2y0 CommentsNewscoding, community, decorator, development, engineering, inclusive, productivity, python, software, tutorial

Decorators are a powerful and versatile tool that allows you to modify the behavior of functions without permanently altering their original code. They work by wrapping a function in another function, which adds some extra functionality before or after the original function executes. What they are: Decorators are higher-order functions, meaning they take another function as an argument and return a new function. The new function returned by the decorator typically acts as a wrapper around the original function, adding or modifying its behavior. How they work: Defining the Decorator: You create a function that takes another function as its…

08 Jul

Kdash – a true opensource K8s micro IDE

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, kdash, productivity, software

although there are multiple CLI GUI ide's for Kubernetes , NONE yet remained open source for the long run, https://medium.com/@seifeddinerajhi/explore-user-friendly-desktop-kubernetes-open-source-ides-5315516b0752 KDash will remain opensourced till aliens come in touch ... promise , so star! , Fork! , share ! get your community involved , we wish to get your feedback and PRs https://github.com/target-ops/kdash/releases/tag/v0.2.0 Source link lol

08 Jul

3 Amazing Productivity Apps for Linux

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, Linux, productivity, software, ubuntu

I use Ubuntu 24.04 as my daily driver on my main laptop and these are some of the best native Linux apps that I use on a daily basis. 1. Iotas Iotas is a note taking application for Linux distributions that is available in the Ubuntu repositories or as a Flatpak that you can download from Flathub. It's the Linux equivalent of Apple Notes for me, it doesn't have all of the features but is enough for me. Iotas allows you to write in plain text as well as markdown and offers an editing and viewing mode to see how…

08 Jul

Working on Something You Hate for 7 Years – How to Escape a Professional Crisis

stp2y0 CommentsNewscareer, coding, community, development, engineering, help, inclusive, learning, productivity, software

Have you ever found yourself with a feeling of emptiness, feeling some kind of melancholy that you can't explain? If the answer is yes, let me tell you that I have felt it too, and it hasn't been easy to turn it off. In this post, I want to share the personal and professional crisis that I'm going through and the things that I'm doing to escape it. Before continuing, let me tell you that I know how crazy this story is going to sound and how hard it is to believe it, but it's mine and it's the only…

07 Jul

Example article title

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, software, test

Some random text with a link. Serious title 8 Add some text here and there! Source link lol

02 Jul

Boost Team Efficiency with Smaller PRs

stp2y0 CommentsNewscicd, coding, community, development, devops, engineering, inclusive, productivity, software

Ever felt overwhelmed by massive Pull Requests (PRs) that drag on for days, or even weeks? John Kline from Riot Games has the answers you’ve been looking for. In a recent DevLogue episode, John dished out game-changing insights on how reducing PR size can supercharge your team's performance. Slice and Dice: Breaking Down the Work The first step to conquering PR bloat is breaking down work into bite-sized chunks. Forget those monstrous, long-lived PRs. Instead, aim for short-lived PRs that deliver small, incremental changes daily. This not only makes reviews a breeze but also minimizes risk and integration issues. Two…

02 Jul

Uttam Prayas Foundation: Growing Education and Health

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, ngo, productivity, software, uttamprayasfoundation

The Uttam Prayas Foundation is a remarkable organization making a big difference in Greater Noida West. They help people in need and care deeply about the environment. Their belief, "True education lies in doing charity, serving others, and doing so without ego," drives all their efforts. This means they believe the best way to learn is by helping others without expecting anything in return. Let’s look at how the Uttam Prayas Foundation makes a positive change in the world. Here are some of their amazing programs and activities that benefit the community. Health and Well-Being Programs Free Health Check-Up CampsThe…

01 Jul

Split & Group Text and Perform Distinct on Each Group

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, programming, software, tutorial

Problem description & analysis: Below is an irregularly categorized detail table. Column A and column B are categories and both have duplicate values. Column C contains detailed data consisting of strings separated by "comma+space", and there are duplicates among the string values. Task: Split detail data in each category, group them by category, get unique values of each group, and concatenate them using "comma+space". Solution: Use SPL XLL to enter the following formula: =spl("=E@b(?.group(~1,~2;~.conj(~3.split@ct()).id().concat("","")))",A2:C12) Enter fullscreen mode Exit fullscreen mode As shown in the picture below: Explanation: group()function groups rows and handles data in each group; ~1 represents the first…

27 Jun

Import A TXT File Where The Separator Is Missing In A Column To Excel

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, programming, software, tutorial

Problem description & analysis: We have a comma-separated txt file that has a total of 10 columns. As certain values of the 3rd column do not have separators, that column is missing and the corresponding rows only have 9 columns, as shown in the last rows: We need to import the txt file to an Excel file. If the 3rd column is missing, use space to fill it and then sort rows by the 1st column: A B C D E F G H I J 3 01-0104-0133 MAYO RONIE #2 202403 2024-03-21 22:51:43.000 1449.49 0 0 8 4 01-0120-0137…