Pandas行转列求助：船体线数据保留x、y坐标列转换失败

Hey there! Let’s tackle this hull line data conversion problem— I’ve worked with similar marine engineering datasets before, so let’s break down the solution based on common raw data scenarios.

Common Scenario 1: Each row holds all x/y values for a single hull line #

If your raw data looks like this (each row represents one hull line, with x and y values grouped into single columns):

LineID,x_values,y_values
1,0.0;1.0;2.0,0.5;0.6;0.7
2,0.0;1.0,0.4;0.5
3,0.0;3.0;5.0,0.3;0.8;1.2

Here’s how to split and expand it into a clean x/y column format:

import pandas as pd

# Load your raw data (adjust sep to match your file's delimiter: comma, semicolon, etc.)
df = pd.read_csv('hull_lines.csv', sep=',')

# Split grouped x/y values into lists
df['x'] = df['x_values'].str.split(';')  # Replace ';' with your actual separator (e.g., ',' or '\s+')
df['y'] = df['y_values'].str.split(';')

# Explode both columns to create one (x,y) pair per row
expanded_df = df.explode(['x', 'y'], ignore_index=True)

# Convert x/y from string to numeric types (critical for calculations)
expanded_df['x'] = pd.to_numeric(expanded_df['x'])
expanded_df['y'] = pd.to_numeric(expanded_df['y'])

# Clean up: drop the original grouped columns if you don't need them
final_df = expanded_df.drop(['x_values', 'y_values'], axis=1)

# Check the result
print(final_df.head())

This will give you the desired format:

LineID    x    y
0       1  0.0  0.5
1       1  1.0  0.6
2       1  2.0  0.7
3       2  0.0  0.4
4       2  1.0  0.5

Common Scenario 2: Raw data is alternating x/y values in a single column #

If your data is just a single column of alternating x and y values (no line IDs or grouping):

value
0.0
0.5
1.0
0.6
2.0
0.7
0.0
0.4

Use this approach to pair x and y correctly:

import pandas as pd

df = pd.read_csv('hull_lines_raw.csv', header=None, names=['value'])

# Assign even-indexed rows to x, odd-indexed to y
df['x'] = df['value'].iloc[::2].reset_index(drop=True)
df['y'] = df['value'].iloc[1::2].reset_index(drop=True)

# Drop the original column and remove any rows with missing values
final_df = df.drop('value', axis=1).dropna().reset_index(drop=True)

Key Tips to Avoid Issues #

• Double-check separators: If your data uses spaces, tabs, or another delimiter, update the sep parameter in pd.read_csv() (e.g., sep='\s+' for spaces).
• Validate data types: Always convert x/y to numeric types— otherwise, you’ll run into errors if you try to plot or calculate with the data.
• Handle missing values: If some hull lines have uneven x/y counts, use dropna() or fillna() to clean up based on your engineering requirements.

If your raw data has a different structure (like fixed-width columns, or custom grouping), feel free to share a sample snippet and I’ll tweak the solution! 😊

内容的提问来源于stack exchange，提问作者Student