File size: 1,113 Bytes
f100e2f
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
b7a1682
 
f100e2f
 
b7a1682
 
 
 
 
 
571c2ab
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
uoh-software-project-time-report
================

<!-- WARNING: THIS FILE WAS AUTOGENERATED! DO NOT EDIT! -->

This file will become your README and also the index of your
documentation.

## Install

``` sh
pip install uoh_software_project_time_report
```

## How to use

Fill me in please! Don’t forget code examples:

``` python
pr = Project('key.json')
pr
```

    1DNoNf4glcuMxKoVzHVrFo-MktmsVji1wf4IHeraWH84

``` python
pr.get()
```

    [['name', 'backlog item #', 'hours spent', 'date'],
     ['Hiroshi Doyu', '25', '1', '2022/1/16'],
     ['Michihito Mizutani', '28', '1', '2022/1/16']]

``` python
import pandas as pd
```

``` python
df = pd.DataFrame(pr.get())
df.columns = df.iloc[0]
df = df[1:]
df['backlog item #'] = df['backlog item #'].astype(int)
df['hours spent'] = df['hours spent'].astype(int)
df.date = pd.to_datetime(df.date)
df.date = df.date.dt.strftime("%Y-%m-%d")
pr.put([df.columns.tolist()] + df.values.tolist())
pr.get()
```

    [['name', 'backlog item #', 'hours spent', 'date'],
     ['Hiroshi Doyu', '25', '1', '2022/1/16'],
     ['Michihito Mizutani', '28', '1', '2022/1/16']]