我有一個問題，我試圖讀取一個 .txt 檔案并匯出到 .csv 并使用分隔符通過使用類別的列分隔行。
file.txt 是這樣的
[groups]
admins = user1,user2,user3
users_network = user4,user5
users_m4s = user6,user7,user8,user9
并且.csv檔案應該是
groups
user1 = admins
user2 = admins
user3 = admins
user4 = users_network
user5 = users_network
user6 = users_m4s ... for the rest of element of category line
我試過了
import pandas as pd
import numpy as np
df = pd.read_table("D:\GIT-files\Automate-Stats\SVN_sample_files\sample_svn_input.txt" , sep='\=',engine='python')
print(df)
df.to_csv("D:\GIT-files\Automate-Stats\SVN_sample_files\sample_svn_input_update.csv" , index=None)
df = pd.read_table ("D:\GIT-files\Automate-Stats\SVN_sample_files\sample_svn_input_update.csv" , sep='\=',engine='python')
print(df)
但它沒有創建正確的 .csv 并顯示
uj5u.com熱心網友回復：
我能夠使用這行代碼根據提供的代碼獲得您需要的結果
df = pd.read_csv(r"D:\GIT-files\Automate-Stats\SVN_sample_files\sample_svn_input.txt", sep = '|')
df.columns = ['groups']
df['New Columns'] = df['groups'].apply(lambda x : x.split('=')[0])
df['groups'] = df['groups'].apply(lambda x : ' '.join(x.split('=')[1:]))
df['groups'] = df['groups'].apply(lambda x : x.split(','))
df = df.explode('groups')
df['groups'] = df['New Columns'] ' = ' df['groups']
df = df[['groups']]
df.to_csv("D:\GIT-files\Automate-Stats\SVN_sample_files\sample_svn_input_update.csv" , index = False)
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/487618.html
標籤：Python 熊猫 麻木的 jupyter-笔记本