DEV Community

Judy profile picture

Judy

Like open source, follow open source

One Year Club
8 Week Community Wellness Streak
4 Week Community Wellness Streak
Writing Debut
2 Week Community Wellness Streak
4 Week Writing Streak
1 Week Community Wellness Streak
Determine whether to filter again based on the situation in the filtered result set #92

Determine whether to filter again based on the situation in the filtered result set #92

6
Comments
1 min read

Want to connect with Judy?

Create an account to connect with Judy. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
Row to column conversion involving uncertain columns #eg91

Row to column conversion involving uncertain columns #eg91

5
Comments
1 min read
The Data Lake’s Impossible Triangle

The Data Lake’s Impossible Triangle

6
Comments
10 min read
Search for records containing a specified string group in multi fields #eg90

Search for records containing a specified string group in multi fields #eg90

11
Comments
1 min read
SQL: Generate event sequence numbers within a specified time interval #eg89

SQL: Generate event sequence numbers within a specified time interval #eg89

9
Comments
1 min read
SQL: Split a string with an uncertain number of segments into multiple columns #eg88

SQL: Split a string with an uncertain number of segments into multiple columns #eg88

9
Comments
1 min read
Simple SQL Statements Only Exist in Coursebooks and Training Courses

Simple SQL Statements Only Exist in Coursebooks and Training Courses

6
Comments
7 min read
SQL: Query the records closest to the specified time each day #eg86

SQL: Query the records closest to the specified time each day #eg86

6
Comments
1 min read
Lightweight big data processing technology

Lightweight big data processing technology

9
Comments
9 min read
SQL: Perform statistics at different granularities based on the time span of the data #85

SQL: Perform statistics at different granularities based on the time span of the data #85

7
Comments
2 min read
SQL,Classify time-close events into a group and assign them a number #eg84

SQL,Classify time-close events into a group and assign them a number #eg84

7
Comments
1 min read
SQL: Recursive calculation of tree like hierarchical structure #eg83

SQL: Recursive calculation of tree like hierarchical structure #eg83

6
Comments
2 min read
SQL: Identify associated member groups without common points of association #eg82

SQL: Identify associated member groups without common points of association #eg82

11
Comments
2 min read
Is It Necessary to Use a Specialized In-Memory Database?

Is It Necessary to Use a Specialized In-Memory Database?

9
Comments
10 min read
SQL: Multi field mixed deduplication followed by numbering #eg81

SQL: Multi field mixed deduplication followed by numbering #eg81

6
Comments
2 min read
How to Compute Arrays and Get Record Containing the Largest Value on a MongoDB Collection #80

How to Compute Arrays and Get Record Containing the Largest Value on a MongoDB Collection #80

6
Comments
2 min read
How to Extract Data from Multilayer XML Parent-Child Nodes to Form a List #79

How to Extract Data from Multilayer XML Parent-Child Nodes to Form a List #79

8
Comments
1 min read
Cross-database SQL Migration

Cross-database SQL Migration

7
Comments
14 min read
How to Convert JSON Data into a Two-dimensional Table and Export It to a CSV #78

How to Convert JSON Data into a Two-dimensional Table and Export It to a CSV #78

6
Comments
1 min read
How to Store Specified CSV Columns to a New File #eg77

How to Store Specified CSV Columns to a New File #eg77

8
Comments
1 min read
How to Execute Multi-database Queries via JDBC #eg76

How to Execute Multi-database Queries via JDBC #eg76

6
Comments
1 min read
Find Missing Datetimes from a CSV-format Time Series with Fixed Interval #eg75

Find Missing Datetimes from a CSV-format Time Series with Fixed Interval #eg75

6
Comments
2 min read
How to Execute a SQL Statement on a Different Type of Database #eg74

How to Execute a SQL Statement on a Different Type of Database #eg74

6
Comments
1 min read
What else can Stream&Kotlin evolve into?

What else can Stream&Kotlin evolve into?

6
Comments
6 min read
How many data analysis tasks can BI software handle?

How many data analysis tasks can BI software handle?

6
Comments
5 min read
Top/Bottom N: getting values #eg73

Top/Bottom N: getting values #eg73

7
Comments
1 min read
What to use for data analysis programming, SQL, Python, or esProc SPL?

What to use for data analysis programming, SQL, Python, or esProc SPL?

6
Comments
2 min read
How to Perform Join Queries on Different Types of Databases #72

How to Perform Join Queries on Different Types of Databases #72

6
Comments
1 min read
How to Access Databases using One SQL Statement #eg71

How to Access Databases using One SQL Statement #eg71

6
Comments
1 min read
Something Would Free Data Scientists from Heavy Coding Work

Something Would Free Data Scientists from Heavy Coding Work

6
Comments
9 min read
Concatenate A Set of Indefinite Number of White-space-separated Rows into a Comma-separated String #70

Concatenate A Set of Indefinite Number of White-space-separated Rows into a Comma-separated String #70

6
Comments
2 min read
Low Code Written in the Grid

Low Code Written in the Grid

6
Comments
18 min read
Split a Huge CSV File into Multiple Smaller CSV Files #eg69

Split a Huge CSV File into Multiple Smaller CSV Files #eg69

6
Comments 1
1 min read
Group & Summarize a CSV File #eg68

Group & Summarize a CSV File #eg68

6
Comments 1
1 min read
Query a CSV File According to Specified Conditions #eg67

Query a CSV File According to Specified Conditions #eg67

6
Comments 1
1 min read
Update the Latest Data in a CSV File to the Database #eg66

Update the Latest Data in a CSV File to the Database #eg66

8
Comments
2 min read
Copy The Other Rows in a Text File the Times Which Is the Number in the Last Row #eg65

Copy The Other Rows in a Text File the Times Which Is the Number in the Last Row #eg65

6
Comments
2 min read
Align Merge Two CSV Files according to Namesake Fields #eg64

Align Merge Two CSV Files according to Namesake Fields #eg64

6
Comments
1 min read
Getting members according to primary key values #eg63

Getting members according to primary key values #eg63

7
Comments
1 min read
Convert Each Whites-space-separated Text Block into a Row #eg62

Convert Each Whites-space-separated Text Block into a Row #eg62

8
Comments
1 min read
Perform Distinct on Ordered Numbers in a Text File #eg61

Perform Distinct on Ordered Numbers in a Text File #eg61

8
Comments
1 min read
Filter a CSV file and re-arrange it by category #eg60

Filter a CSV file and re-arrange it by category #eg60

6
Comments 1
1 min read
Getting a member according to primary key value #eg59

Getting a member according to primary key value #eg59

6
Comments
1 min read
Getting positions of members according to primary key values #eg58

Getting positions of members according to primary key values #eg58

6
Comments
1 min read
Getting the record containing the maximum value of a specified field #eg57

Getting the record containing the maximum value of a specified field #eg57

5
Comments
1 min read
Convert CSV Data into Multilevel JSON #eg56

Convert CSV Data into Multilevel JSON #eg56

6
Comments
1 min read
Replace All Duplicates of Each Word with Underlines #eg55

Replace All Duplicates of Each Word with Underlines #eg55

7
Comments
1 min read
Getting the record containing the minimum value of a specified field #eg54

Getting the record containing the minimum value of a specified field #eg54

7
Comments
1 min read
Check Each Line of a CSV File and Output Specific Information according to Certain Requirements #53

Check Each Line of a CSV File and Output Specific Information according to Certain Requirements #53

6
Comments
2 min read
Replace Duplicate Digits in Every 9-digit Number in a Text File with Non-duplicate Ones #eg52

Replace Duplicate Digits in Every 9-digit Number in a Text File with Non-duplicate Ones #eg52

7
Comments
1 min read
Reverse Rows in a Text File #eg51

Reverse Rows in a Text File #eg51

8
Comments 3
1 min read
The Difference between Each Value in a Certain Column and Its Previous One and Display Result

The Difference between Each Value in a Certain Column and Its Previous One and Display Result

6
Comments
2 min read
Getting the first record meeting the specified condition #eg49

Getting the first record meeting the specified condition #eg49

6
Comments
1 min read
Multi-condition filtering #eg48

Multi-condition filtering #eg48

6
Comments
1 min read
Getting members based on a specified condition #47

Getting members based on a specified condition #47

6
Comments
1 min read
Getting positions of members based on a specified condition #eg46

Getting positions of members based on a specified condition #eg46

11
Comments
1 min read
Split a large csv file into smaller files #eg45

Split a large csv file into smaller files #eg45

7
Comments
1 min read
Read specified columns from a csv file #eg44

Read specified columns from a csv file #eg44

6
Comments
1 min read
SQL, in each group modify the null value of a specified column as its neighboring value #eg43

SQL, in each group modify the null value of a specified column as its neighboring value #eg43

7
Comments
1 min read
SQL, extract unique values of JSON format field from each group #eg42

SQL, extract unique values of JSON format field from each group #eg42

6
Comments
2 min read
loading...