Category "split"

Split translation results with pandas in Google Colab

Hi everyone I'm doing a traslation of words in csv/excel files using Google Colab and Pandas here is my code: import pandas as pd from googletrans import Transl

Formula to create a row for every value of a comma-delimited list - GSheets

I am trying to write a formula that will take a set of columns and pair them into separate rows with a comma-delimited list. In SQL, I would do this with a left

split strings that contain more than one substring

I have a list of strings names names = ['Acquaintance Muller', 'Vice president Johnson Affiliate Peterson Acquaintance Dr. Rose'] I want to split the strings th

String Split function in MySQL

can anybody tell me how to implement a split function in mysql which behaves like Javascript split. I want a function like this SELECT Split('a,b,c,d', ',') A

Google Sheets Split function with Array

I have a table of current work hours in column A. Column B has newly assigned work hours. Column C just sums up the first two columns to show the new work hours

Keyword repeated multiple times in context from string in R

I have a dataset (z) with strings which are very long in z$txt. I also have a dictionary (incd) of keywords that need to be identified. In the column z$inc.term

Split comma-separated strings in a column into separate rows

I have a data frame, like so: data.frame(director = c("Aaron Blaise,Bob Walker", "Akira Kurosawa", "Alan J. Pakula", "Alan Parker", "A

Splitting a file based on number of records and file size

I have a file which contains 100 records... Each record has different size, like some are 1 KB while some are 1 MB. I want to split the file based upon number o

Split string cell into multi rows but keep original row

I have a macro that splits a string (list of names) using a space as the delimiter and creates a new row for each name while keeping all data the same in other

Formating a string to keep the wanted

I have an issue with this code: from netmiko import ConnectHandler from re import search lsite=[] try: NetworkDevice = { "host" : "ip", "u

How do I use regex to match a substring before/after the colon?

I want to split info into Refseq ID, cDNA level change and Protein level change, where Refseq ID represents the substring from the start to the first colon :, c

How to split input text file that has string and doubles?

I am to read from an .txt input and sort into array by line (read: first name, last name, grade1, grade 2, grade3) but I am having issues. I am assuming that I

Join each term with list of keywords

Probably a simple problem and you can help me quickly. I have a vector with all the terms contained in a list of keywords. Now I want to join each term with all

How could I call hundreds in python?

When I split certain numbers into "ones" and "tens" in python, like that (98) we code >>> num = 98 ones = num % 10 tens = num // 10 print(ones) = 8

How to split a string with whitespace and underscore in Python [closed]

I hope this will find you guys well, can you please show me how to split text with whitespace and underscore? For Example, txt= "Im Alex_from_

ValueError with pandas apply function returning output of variable shape

I have a pandas dataframe with three columns structured like this: Sample Start End <string> <int> <int> The values in "Start" and "End

How to get a specific number of cells using an array formula in Google Sheets

I want to pre-process my data like the Result section of the attached image before flattening and using it. I want to write an array formula in the cells marked

Duplicate and Split Row based on value by using SQL Query?

I have set of data and wants to split multiple rows based on the column value. For Example, Source Data: Expected Output: Thanks, Lawrance A

Difference between GroupSplitShuffle and GroupKFolds

As the title says, I want to know the difference between sklearn's GroupKFold and GroupShuffleSplit. Both make train-test splits given for data that has a group

Python web scraping error: 'NoneType' object is not callable after using split function

I'm a beginner writing my first scraping script trying to extract company name, phone number, and email from the following page. So far my script successfully