python更改数据框指定位置的数据_python-在Pandas中创建空数据框以指定列类型

最新推荐文章于 2024-06-27 11:51:55 发布

weixin_39637545

最新推荐文章于 2024-06-27 11:51:55 发布

阅读量261

点赞数

文章标签： python更改数据框指定位置的数据

遇到相同问题后，我发现了这个问题。我更喜欢以下解决方案(Python 3)，用于创建没有索引的空DataFrame。

import numpy as np

import pandas as pd

def make_empty_typed_df(dtype):

tdict = np.typeDict

types = tuple(tdict.get(t, t) for (_, t, *__) in dtype)

if any(t == np.void for t in types):

raise NotImplementedError('Not Implemented for columns of type "void"')

return pd.DataFrame.from_records(np.array([tuple(t() for t in types)], dtype=dtype)).iloc[:0, :]

测试一下...

from itertools import chain

dtype = [('col%d' % i, t) for i, t in enumerate(chain(np.typeDict, set(np.typeDict.values())))]

dtype = [(c, t) for (c, t) in dtype if (np.typeDict.get(t, t) != np.void) and not isinstance(t, int)]

print(make_empty_typed_df(dtype))

出：

Empty DataFrame

Columns: [col0, col6, col16, col23, col24, col25, col26, col27, col29, col30, col31, col32, col33, col34, col35, col36, col37, col38, col39, col40, col41, col42, col43, col44, col45, col46, col47, col48, col49, col50, col51, col52, col53, col54, col55, col56, col57, col58, col60, col61, col62, col63, col64, col65, col66, col67, col68, col69, col70, col71, col72, col73, col74, col75, col76, col77, col78, col79, col80, col81, col82, col83, col84, col85, col86, col87, col88, col89, col90, col91, col92, col93, col95, col96, col97, col98, col99, col100, col101, col102, col103, col104, col105, col106, col107, col108, col109, col110, col111, col112, col113, col114, col115, col117, col119, col120, col121, col122, col123, col124, ...]

Index: []

[0 rows x 146 columns]

以及数据类型...

print(make_empty_typed_df(dtype).dtypes)

出：

col0 timedelta64[ns]

col6 uint16

col16 uint64

col23 int8

col24 timedelta64[ns]

col25 bool

col26 complex64