我正在尝试从文本创建表格

Question

我想创建一个表，其中两列用"分隔：&"；。所以大写的单词作为第一列，在"："作为第二列。我最初试图从PDF中完成这项工作，但不起作用，所以我把它复制到一个文本文件中，认为这样可能更容易。我是Python的新手，但这是我需要知道的，以使将数据传输到电子表格更容易。我该怎么做？？我很失落：’(

DSNY SR# is: 2018EC0000000
PROGRAM: sampleNYC
CONTACT-ROLE: property manager
CONTACT-FIRST-NAME: Peter
CONTACT-LAST-NAME: Parker
CONTACT-EMAIL: [e-mail]
CONTACT-PHONE: [phone]
CONTACT-PHONE-TYPE: Mobile
SITE-ADDRESS-1: 0000 00 STREET BROOKLYN 11219
SITE-BORO: 3-BROOKLYN
SITE-TYPE: rental
SITE-UNITS: 16
MGMT-COMPANY-NAME: Parker Realty Corp
MGMT-COMPANY-CONTACT-FIRST-NAME: Peter
MGMT-COMPANY-CONTACT-LAST-NAME: Parker
MGMT-COMPANY-CONTACT-TITLE: Manager
MGMT-COMPANY-ADDRESS-1: 0000 23rd Street
MGMT-COMPANY-City: Brooklyn
MGMT-COMPANY-State: NY
MGMT-COMPANY-ZIP: 11219
MGMT-COMPANY-CONTACT-EMAIL: [e-mail]
MGMT-COMPANY-CONTACT-PHONE: [phone]
MGMT-COMPANY-CONTACT-PHONE-TYPE: Mobile
MGMT-COMPANY-CONTACT-NOTIFICATION: YES
REG-SOURCE: Word of Mouth
REG-SOURCE-DETAIL:
TERMS-CONDITIONS: Yes

Answer 1

您可以使用read_table:

将常规分隔文件读取到DataFrame中。

---

例如，

import pandas as pd
df = pd.read_table(
'/path/to/file.txt', 
sep=':', 
header=None, 
names=['col1','col2']
)