python - 将数据从行移动到列？

Question

我有一个包含以下内容的数据框：

  | 0           | 2                            |
  |-------------|------------------------------|
1 | Sale Date   | 3/5/2020                     |
2 | Case Number | CJ-19-2858                   |
3 | Plantiff    | Lakeview Loan Servicing, LLC |
4 | Defendant   | Tom                          |
5 | Address     | 111 Looper                   |
6 | Sale Date   | 3/5/2020                     |
7 | Case Number | CJ-18-7039                   |
8 | Plantiff    | FNB Community Bank           |
9 | Defendant   | Sally                        |
10| Address     | 123 Oak                      |
11| Sale Date   | 3/5/2020                     |
12| Case Number | CJ-18-5109                   |
13| Plantiff    | FNB Community Bank           |
14| Defendant   | Bill                         |
15| Address     | 545 Main                     |

如何将其重新排序为这样的数据框？：

| Sale Date | Case Number | Plantiff                     | Defendant | Address    |
|-----------|-------------|------------------------------|-----------|------------|
| 3/5/2020  | CJ-19-2858  | Lakeview Loan Servicing, LLC | Tom       | 111 Looper |
| 3/5/2020  | CJ-18-7039  | FNB Community Bank           | Sally     | 123 Oak    |
| 3/5/2020  | CJ-18-5109  | FNB Community Bank           | Bill      | 545 Main   |

标签： pythonpandas

Answer 1

就像写作一样简单df.T