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
How to Store Specified CSV Columns to a New File #eg77

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

5
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
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?

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

Top/Bottom N: getting values #eg73

8
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

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

How to Access Databases using One SQL Statement #eg71

11
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
Low Code Written in the Grid

Low Code Written in the Grid

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

9
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

9
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

9
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

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

Convert CSV Data into Multilevel JSON #eg56

8
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

7
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
Parse a csv file having a primary-sub tables structure #eg41

Parse a csv file having a primary-sub tables structure #eg41

6
Comments
2 min read
Add a compute column to a csv file #eg40

Add a compute column to a csv file #eg40

8
Comments
1 min read
Process a large csv file with parallel processing #eg39

Process a large csv file with parallel processing #eg39

6
Comments 1
1 min read
Compare large csv files #eg38

Compare large csv files #eg38

6
Comments 2
2 min read
Something could double the development efficiency of Java programmers

Something could double the development efficiency of Java programmers

7
Comments
6 min read
Split values of a field in a database table and transform it to new fields #eg37

Split values of a field in a database table and transform it to new fields #eg37

6
Comments
1 min read
Get the whole group where at least one member meets the specified condition #eg36

Get the whole group where at least one member meets the specified condition #eg36

6
Comments
2 min read
Parse a csv file where field values are enclosed by quotation marks and contain carriage return #eg35

Parse a csv file where field values are enclosed by quotation marks and contain carriage return #eg35

6
Comments
1 min read
Compare two csv files #eg34

Compare two csv files #eg34

7
Comments 1
1 min read
Java, perform COUNT on each group of a large csv file #eg33

Java, perform COUNT on each group of a large csv file #eg33

6
Comments
2 min read
Java, fill each row having a null value in a csv file with values in the directly previous row #eg32

Java, fill each row having a null value in a csv file with values in the directly previous row #eg32

6
Comments
1 min read
To Index Data is To Sort Data

To Index Data is To Sort Data

8
Comments
5 min read
Group and Summarize data, and align to the specified sequence #eg31

Group and Summarize data, and align to the specified sequence #eg31

6
Comments
1 min read
SQL, mark continuous rows with sequence numbers #eg30

SQL, mark continuous rows with sequence numbers #eg30

8
Comments
1 min read
SQL, compute cumulative sums according to the termination condition #eg29

SQL, compute cumulative sums according to the termination condition #eg29

7
Comments 1
1 min read
SQL, parse json data #eg28

SQL, parse json data #eg28

11
Comments
1 min read
SQL, concatenate multiple rows of strings and remove duplicates #eg27

SQL, concatenate multiple rows of strings and remove duplicates #eg27

6
Comments
1 min read
SQL, output associated records having many-to-many relationship row by row #eg26

SQL, output associated records having many-to-many relationship row by row #eg26

8
Comments
1 min read
loading...