Skip to content Skip to sidebar Skip to footer
Showing posts with the label Awk

Removing Duplicated Lines From A Txt File

I am processing large text files (~20MB) containing data delimited by line. Most data entries are d… Read more Removing Duplicated Lines From A Txt File

Split Csv File Thousands Of Times Based On Groupby

(An adaptation of David Erickson's question here) Given a CSV file with columns A, B, and C and… Read more Split Csv File Thousands Of Times Based On Groupby

Multiple Regex Replacements Based On Lists In Multiple Files

I have a folder with multiple text files inside that I need to process and format using multiple re… Read more Multiple Regex Replacements Based On Lists In Multiple Files

To Sum Column With Condition

I have data in textfile. example. A B C D E F 10 0 0.9775 39.3304 0.9311 60.5601 10 1 0.9802 32.32… Read more To Sum Column With Condition

Combine Lines With Matching Keys

I have a text file with the following structure ID,operator,a,b,c,d,true WCBP12236,J1,75.7,80.6,65.… Read more Combine Lines With Matching Keys

Compare A .txt And .csv File And Need To Replace With Matching Name In .csv File To .txt

file1.txt [fields:WinSpc:defect] a=b b=c hello=hi [fields:ROCKET PROJECT:ticket] description=Descr… Read more Compare A .txt And .csv File And Need To Replace With Matching Name In .csv File To .txt

Python Remove Phone Numbers From String

I have a text file that looks like this: rgf34 | 9 | 2015-07-20 | hello this is my number 123456789… Read more Python Remove Phone Numbers From String