我有一個(gè)以下格式的 .txt 數(shù)據(jù)集：01/01/2018 ['cat', 'bear', 'ant']01/02/2018 ['horse', 'wolf', 'elephant']01/03/2018 ['parrot', 'bird', 'fish]我想使用 PYTHON 并將其設(shè)置為以下格式的 2 列： 'Date' 'Animal'01/01/2018 cat01/01/2018 bear 01/01/2018 ant01/02/2018 horse01/02/2018 wolf01/02/2018 elephant01/03/2018 parrot01/03/2018 bird01/03/2018 fish（txt 文件實(shí)際上更長(zhǎng)，但為了更好地理解而進(jìn)行了簡(jiǎn)化）。我不知道如何繼續(xù)：read_csv或open（但隨后它會(huì)像對(duì)象一樣讀取它）？我應(yīng)該設(shè)置分隔符嗎？我嘗試了幾件事，但沒(méi)有任何作用。提前致謝
1 回答
郎朗坤
TA貢獻(xiàn)1921條經(jīng)驗(yàn) 獲得超9個(gè)贊
使用 pandas 創(chuàng)建表：
import ast
import pandas as pd
dates = []
animals = []
lines = []
# Read file lines
with open('file.txt', 'r') as f:
lines = f.readlines()
for l in lines:
# Spliting date and animals
date_string, animals_string = l.split(' ', maxsplit=1)
# Safely evaluate animals list
animals_list = ast.literal_eval(animals_string)
# Duplicate date the amount of animals in that date
dates.extend([date_string] * len(animals_list))
# Append animals
animals.extend(animals_list)
# Create dataframe for the dates and animals
df = pd.DataFrame({'Date': dates, 'Animal': animals})
# Print the dataframe
print(df)
輸出：
Date Animal
0 01/01/2018 cat
1 01/01/2018 bear
2 01/01/2018 ant
3 01/02/2018 horse
4 01/02/2018 wolf
5 01/02/2018 elephant
6 01/03/2018 parrot
7 01/03/2018 bird
8 01/03/2018 fish
添加回答
舉報(bào)
0/150
提交
取消