[split pandas cell into rows]将一个包含字符串或 list 的 cell，使用特定字符，将 cell 分成多行，同行其他 cells 复制值 #pandas

100%

[split pandas cell into rows]将一个包含字符串或 list 的 cell，使用特定字符，将 cell 分成多行，同行其他 cells 复制值 #pandas

✓ Published0🌍 Public

Last edited Jan 25, 2019

Created on Nov 6, 2018

This example shows a pandas data-wrangling technique that transforms a DataFrame by splitting a single cell containing a delimited string or list into multiple rows while duplicating the other column values across the new rows. The function `splitDataFrameList` accepts a DataFrame, the target column name, and a separator string, then uses `df.apply` along the rows and a helper function to parse each cell. It relies on the `collections.Iterable` check and the `str.split` method to separate values, ultimately constructing a new DataFrame from the accumulated row dictionaries via `pd.DataFrame`.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 575a4d1a506d4f39d35f

This example presents a collection of Python code snippets for data manipulation with the pandas library, focusing on common DataFrame operations. It demonstrates techniques for filtering rows based on column values, handling missing data, renaming columns, and performing data type conversions. The snippets also cover more advanced operations like pivot tables, merging delimited values, and using `pd.melt` for reshaping data. The code includes functions like `df.column_name.unique()`, `pd.pivot_table`, and `df.assign` to illustrate practical workflows for cleaning and transforming tabular data.

SSav10

55% match

Loading thumbnail…

A `.split()` function for excel—assumes 0 index, "-" delimiter, and reference cell "A2" but are all customizable. Outputs a string representation of the formula

This example generates spreadsheet formulas that split text from a reference cell into separate parts. It shows a Python function that recursively builds nested Excel-style `SEARCH`, `LEFT`, and `MID` calls. The code defines `build(i, delimiter='"-"', reference_cell="A2")`, which assumes a zero-based index and a hyphen delimiter, but all parameters are customizable. The output is a string representation of the formula, constructed through the helper `recurse` to incrementally locate delimiter positions. It does not execute or render the formula; it only produces the textual formula string.

BBBischof

48% match

Loading thumbnail…

Gist feea61c798fdb955f16b5ba785974e1a

This example highlights differences between two pandas DataFrames by key. It displays the two records side-by-side, transposing them into a single table where each column represents a field. Any column containing differing values between the two rows is visually marked with a yellow background. The implementation uses the pandas `DataFrame.style.apply` method to apply a custom `highlight_diff` function that checks for uniqueness across the row pairs, returning conditional formatting styles for the table.

JJonasHeylen

47% match

Loading thumbnail…

First steps

This example shows the initial steps of loading and inspecting a malformed CSV file in Python using pandas and basic file handling. It opens the file with the built-in `open()` function, reads it line by line, strips whitespace, and splits each line into a list of values with `split(",")`. The resulting nested list is converted into a pandas DataFrame via `pd.DataFrame`, and the first 20 rows are displayed to examine the data structure. The snippet highlights data cleaning challenges, as many fields contain `None` values and numeric entries are in scientific notation.

RRobinL

46% match

Loading thumbnail…

[提取字符串中英文部分] #string

This example demonstrates a Python utility that splits a mixed Chinese-English string into its Chinese and English components, returning them as a tuple. It shows how the function identifies contiguous Chinese characters (including punctuation and spaces) from either the start or end of the input, then isolates the remaining text as the English portion. The code relies on the `re` module’s compiled patterns to match Chinese ranges (`\u4e00-\u9fa5`) and an English punctuation set, with fallback logic to handle cases where the Chinese segment is too short. The implementation includes configurable thresholds for minimum lengths of both extracted parts.

SShawn91

46% match

Loading thumbnail…

[flatten list]铺平 list of lists #array

This example demonstrates two ways to flatten nested lists of arrays in Python. The first method uses a lambda function with a list comprehension to produce a new flattened list. The second method defines a generator function, `flatten`, which recursively yields items from nested iterables while ignoring strings and bytes, using the `Iterable` class from the `collections` module. The example data `[1, 2, [3, 4, [5, 6], 7], 8]` is processed by the generator, printing each number in order.

SShawn91

46% match

Loading thumbnail…

Reorder pandas column using indexes

This example demonstrates how to reorder the columns of a pandas DataFrame based on a custom index sequence. It first extracts the existing column names into a list, then uses list comprehension to select columns by their numeric positions—specifically indices 3, 2, 1, 4, 6, 4, and 8—creating a new DataFrame with the rearranged order. The code relies on pandas’ column indexing and list slicing to perform the reordering.

KKevinGutowski

45% match

Loading thumbnail…

[print_unicode] python2 下在命令行中正常打印嵌套在 dict/list 内的 unicode 字符 #python #string

This example shows a Python 2 utility function that makes nested Unicode characters inside dictionaries and lists print correctly to the command line. The function `print_uni` takes any string `s`, applies `repr` to capture its escaped form, and then decodes that representation using `"unicode-escape"` to reveal the actual Unicode glyphs. It relies on the built-in `repr` function and the string `decode` method, demonstrating a workaround for Python 2’s default ASCII-based printing of container structures. The code is a standalone snippet from a gist by Shawn91, focusing on a common debugging pain point.

SShawn91

44% match