logo
Tags down

shadow

Max Values from Text File that has multiple columns


By : Matthew Nalett
Date : October 14 2020, 02:15 PM
I wish this help you After doing some calculations i have a text file in the format: , here is my solution
code :
import re

def my_sort(val):
    pattern = r'[0-9]+\.[0-9]+'
    p = re.findall(pattern, val)
    return float(p[0])

with open('test.txt', 'r') as f:
    txt = f.read()

pattern1 = r'[a-z]+[0-9]* [a-z]+[0-9]* [0-9]+\.[0-9]+'
p1 = re.findall(pattern1,txt)
p1.sort(key=my_sort)
result = p1[::-1]

with open('text2.txt','w') as f:
    for i in result:
        f.write(i+'\n')
hyp5 hyp6 0.3333333333333333
word5 word6 0.2
word3 word4 0.2
hyp1 hyp2 0.1111111111111111
word1 word2 0.1111
hyp3 hyp4 0.07692307692307693
tear sight 0.1111111111111111
pulled spectacle 0.1111111111111111
statement black 0.1111111111111111
past woman 0.1
section black 0.1
tom answer 0.09090909090909091
man astonishment 0.09090909090909091
answer tom 0.09090909090909091
old lady 0.08333333333333333
boy wonder 0.08333333333333333
chapter tom 0.08333333333333333
turkey statement 0.058823529411764705


Share : facebook icon twitter icon

How to update column text value with concatenation of multiple columns text values?


By : Melissa Williams
Date : March 29 2020, 07:55 AM
I wish did fix the issue. Mysql has built-in function called concat which you can use, something as
code :
Update table_x 
set 
merged_content=
concat('<p>',first_name,' ',last_name,'</p><p><b>Address -</b> ',address,'</p>'); 

Reading multiple text files from a directory and add its columns into one text file in R


By : Dru Kakai
Date : March 29 2020, 07:55 AM
this one helps. I have multiple files in a directory and what I need to achieve is to concatenate(What I mean here is to add columns from other text files into one file) all those text files into one DataFrame. And the final dataframe should contain multiple number of column(same as the number of text files in the directory). For example, file_1 looks like this , Using data.table:
code :
library(data.table)
setDT(dat) #data containing ids
lapply(lf,function(x){
   y<-fread(lf)
   nm<-names(y)[2]
   dat[y,(nm):=get(nm),on="id"]})
lapply(lf,function(x){
       y<-fread(lf)
       nm<-setdiff(names(y),"id")
       dat[y,(nm):=mget(nm),on="id"]})
lapply(lf,function(x){
       y<-fread(lf)
       nm<-setdiff(names(y),"id")
       if (length(intersect(nm,names(dat)))){
         nm_dup<-intersect(nm,names(dat))
         nm_new<-setdiff(nm,nm_dup)
         dat[y,(nm_new):=mget(nm_new),on="id"]
         dat[y,paste0(nm_dup,z):=mget(paste0("i.",nm_dup)),on="id"]
       }else dat[y,(nm):=mget(nm),on="id"]})

Is there a way to combine columns from multiple text files into a single text file using Matlab?


By : user3586429
Date : March 29 2020, 07:55 AM
hop of those help? Try using readmatrix instead. What's nice about this function is that it can handle NaN values, which is what some of your text files have. Also, because your text files have commas, this will confuse the function and think there is a second empty column. Just subset into the first column to be safe. Please note that this function exists in version 2019a or greater:
code :
textDataMatrix = zeros(5478, 4);
t = {'prec', 'rsds', 'tmax', 'tmin'};
for k = 1:4
    Mead_NE_Climate_1985_1999 = [t{k} '_outfile_mead.txt'];
    textData = readmatrix(Mead_NE_Climate_1985_1999);
    textDataMatrix(:,k) = textData(:,1);
end

Perl - Problem with splitting columns in tab delimited text file and replacing columns with new values


By : abam0686
Date : March 29 2020, 07:55 AM
I hope this helps . There's already some decent answers, but I'd like to show you a simpler solution. This script, you'd use like this:

Perl: How to join two columns of a text file, in which values of the first column should match in order with the values


By : Sucre Yang
Date : October 08 2020, 03:00 AM
will be helpful for those in need I'm not sure about this as I haven't seen your data. But I think you're making this far harder than necessary. I think that everything you need for each gene is in a single line of the input file, so you can process the file a line at a time and not use any extra variables. Something like this:
code :
open (IN, "Alu.txt");
open (OUT, ">Alu_subfamlength3.csv");

while ($a = <IN>) {
    @data = split (/\t/, $a);
    print "Gene: $data[10] / Length: ", $data[7] - $data[6], "\n";
}
use strict;
use warnings;

open (IN, "Alu.txt");
open (OUT, ">Alu_subfamlength3.csv");

while (<IN>) { # This puts the line into $_
    my @data = split (/\t/); # split uses $_ by default
    print OUT "Gene: $data[10] / Length: ", $data[7] - $data[6], "\n";
}
use strict;
use warnings;

open (IN, "Alu.txt");
open (OUT, ">Alu_subfamlength3.csv");

while (<IN>) { # This puts the line into $_
    my ($start, $end, $gene) = (split /\t/)[6, 7, 10]; # split uses $_ by default
    print OUT "Gene: $gene / Length: ", $end - $start, "\n";
}
use strict;
use warnings;

while (<>) { # Empty <> reads from STDIN
    my ($start, $end, $gene) = (split /\t/)[6, 7, 10];
    # print to STDOUT
    print "Gene: $gene / Length: ", $end - $start, "\n";
}
$ ./filter_genes < Alu.txt > Alu_subfamlength3.csv
Related Posts Related Posts :
  • Read a text file and remove all characters except alphabets & spaces in Python
  • Compute all powerset intersections of two lists
  • Applying literal_eval on string of lists of POS tags gives ValueError
  • Modelling a logic puzzle
  • What is the meaning of Copy_X in sklearn linear models
  • selenium.common.exceptions.ElementNotInteractableException: Message: Element is not displayed
  • pydev debugger does not stop in breakpoint
  • Python windows path regex
  • Flask and selenium-hub are not communicating when dockerised
  • How to use groupby on a single column and perform comparisons for multiple columns in Pandas?
  • Locate a python script without absolute path
  • Custom-formatted Django form errors appearing twice
  • Matploblib: Paint cells of matrix based on indexes stored in array
  • How to repeat a drawing horizontally in pygame (drawing done in a class method)?
  • How to convert numpy array from numpy.int64 to datetime?
  • How do I pad values in the array so that I get this?
  • Numpy generate random whole number
  • How to find Price Tag with Dollar Sign, thousand delimiter AND decimal point by Python Regex
  • Python Scikit - bad input shape when calling sklearn.metrics.precision_recall_curve
  • struggle to understand tkinter multi classes
  • Wait for Button to be pressed after selecting Radiobutton then run command (Tkinter)
  • BeautifulSoup find() returns tags, but no value between the tags. Why is this?
  • Approximation of F using Hooke's Law
  • suggestion on filtering lists items that corresponds to other lists
  • Sort a list using a partial match in another list
  • Can filter() contain two conditions?
  • Kivy popup button content doesn't show in the button
  • Python - masking in a for loop?
  • Find which term is repeated in a string, when given a known number of N occurrences in the string
  • Replace all elements in list Python
  • How can I speed up my MySQL (InnoDB) inserts?
  • Can I input a Byte Tensor to my RNN/LSTM model?
  • Autoincrement file names
  • Problems transforming data in a dataframe
  • Cant send keys with the selenium webdriver in python
  • Conditionally replacing strings in Pandas column
  • How to process data after reading from QIODevice.read()?
  • Iterating over a list of integers using map and using a list of functions
  • How to rewrite this SQL query in Python with pandas?
  • Matplotlib: boxplot stops programme execution
  • Optimize for cumprod() with two variables
  • python responses - Not all requests have been executed
  • Guaranteed method to match longest string in regular expression alternation
  • Trouble when storing API data in Python list
  • Running a python script through Windows Scheduler not working
  • python beginner syntax statement if-elif
  • Why does python find the line 'ens' but not 'tun' when using `for line in open()`
  • How to add result of previous row to contents of present row?
  • Train LSTM with probabilistic labels
  • AWS Cloudwatch Logstream - What is the key, and how can I set it when getting the logstream
  • Page Pagination/Scraping with Requests/BeautifulSoup
  • How to fix NoReverseMatch on redirect
  • Using a list to name output files in Arcpy
  • Need help conditionally vectorizing a list
  • I want to apply a threshold to pixels in image using python. Where did I make a mistake?
  • Problems unsing Beautiful Soup
  • python binning data openAI gym
  • Python: Argparse with list of lists
  • Creating Columns in m x 1 dataframe based on spaces in each row?
  • Explicit relative imports within a package not using the keyword from
  • shadow
    Privacy Policy - Terms - Contact Us © voile276.org