Python-将数据框内的数据取出到另一个单元中 [英] Python - take out the data inside cell of dataframe to another cells

问题描述

这是具有14列的数据帧的单个单元格中的数据.单元格是列的元素.有45k +这种细胞，手动操作真是个地狱.

This is the data in single cell of dataframe with 14 columns. Cell is the element of column. There are 45k+ this kind of cells, to do it manually is a hell.

一个单元格数据

我想对此单元格做三件事:

I'd like to do with this cell 3 things:

1. 将带有地址，状态，邮政编码的文本部分移动到另一列；
2. 删除单元格的钩子()；
3. 分开2列经度和纬度.

怎么可能?

推荐答案

下面是一个简单有效的示例，其中包含2个数据点:

Here's a simple, working example with 2 data points:

text1 = """30881 EKLUTNA LAKE RD
CHUGIAK, AK 99567
(61.4478, -149.3136)"""

text2 = """30882 FAKE STR
CHUGIAK, AK 98817
(43.4478, -119.3136)"""

d = {'col1': [text1, text2]}

df = pd.DataFrame(data=d)

def fix(row):
  #We split the text by newline
  address, cp, latlong =  row.col1.split('\n')

  #We get the latitude and longitude by splitting by a comma
  latlong_vec = latlong[1:-1].split(',')

  #This part isn't really necessary but we create the variables for claity
  lat = float(latlong_vec[0])
  long = float(latlong_vec[1])

  return pd.Series([address + ". " + cp, lat, long])


df[['full address', 'lat', 'long']] = df.apply(fix, axis = 1)

3个新列的输出:

df['full address']
0    30881 EKLUTNA LAKE RD. CHUGIAK, AK 99567
1           30882 FAKE STR. CHUGIAK, AK 98817

df['lat']

0    61.4478
1    43.4478
Name: lat, dtype: float64

df['long']

0   -149.3136
1   -119.3136
Name: long, dtype: float64

名称:完整地址，dtype:对象

Name: full address, dtype: object

这篇关于Python-将数据框内的数据取出到另一个单元中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！