Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Plot APIs improvement in Series #665

Closed
HyukjinKwon opened this issue Aug 21, 2019 · 1 comment
Closed

Plot APIs improvement in Series #665

HyukjinKwon opened this issue Aug 21, 2019 · 1 comment
Labels
enhancement New feature or request

Comments

@HyukjinKwon
Copy link
Member

Koalas: https://koalas.readthedocs.io/en/latest/reference/series.html#plotting
pandas: https://pandas.pydata.org/pandas-docs/stable/reference/series.html#plotting

We should improve Koalas' plot more.
@HyukjinKwon HyukjinKwon added the enhancement New feature or request label Aug 21, 2019
@HyukjinKwon HyukjinKwon mentioned this issue Aug 21, 2019
Merged
HyukjinKwon added a commit that referenced this issue Aug 21, 2019
@HyukjinKwon
Document and test Series.plot(...) usage (#668)
7a76730 
This PR adds documentation and test for `Series.plot(...)` usage. See https://pandas.pydata.org/pandas-docs/stable/reference/series.html#plotting

```python
import databricks.koalas as ks
import pandas as pd

pdf_1 = pd.DataFrame({
            'a': [1, 2, 3, 4, 5, 6, 7, 8, 9, 15, 50],
        }, index=[0, 1, 3, 5, 6, 8, 9, 9, 9, 10, 10])

kdf_1 = ks.DataFrame(pdf_1)
pdf_1['a'].plot("bar", colormap='Paired').figure.savefig("output3.png")
kdf_1['a'].plot("bar", colormap='Paired').figure.savefig("output4.png")
```

Partially addresses #665
This was referenced Aug 21, 2019
Merged
Merged
Merged
Merged
HyukjinKwon added a commit that referenced this issue Aug 22, 2019
@HyukjinKwon
Add plot.pie in Series (#669)
221cb6c 
This PR add series.plot.pie in Series.

Can be tested as below:

```python
import databricks.koalas as ks
ks.range(10).to_pandas().id.plot.pie().figure.savefig("image.png")
ks.range(10).id.plot.pie().figure.savefig("image.png")
```

![image](https://user-images.githubusercontent.com/6477701/63404049-aa7da480-c41c-11e9-9472-f33e5c302dc6.png)


If there are more than 1000 rows, it shows as below:

```
ks.range(1001).id.plot.pie().figure.savefig("image.png")
```

![image](https://user-images.githubusercontent.com/6477701/63404022-8a4de580-c41c-11e9-8bc3-848343007f8d.png)

Most of people will use, for instance `df.x.value_counts().plot.pie()`.  This case is similar as bar plot.



Partially addresses #665
HyukjinKwon added a commit that referenced this issue Aug 22, 2019
@HyukjinKwon
Add plot.area in Series (#670)
66aae2a 
This PR add series.plot.pie in Series.

Can be tested as below:

```python
import databricks.koalas as ks
import pandas as pd

pdf = pd.DataFrame({
          'a': [1, 2, 3, 4, 5, 6, 7, 8, 9, 15, 50],
      }, index=[0, 1, 3, 5, 6, 8, 9, 9, 9, 10, 10])

kdf = ks.DataFrame(pdf)
pdf['a'].plot.area(colormap='Paired').figure.savefig("image1.png")
kdf['a'].plot.area(colormap='Paired').figure.savefig("image2.png")
```

![image2](https://user-images.githubusercontent.com/6477701/63408309-aa37d600-c429-11e9-9ab0-ddaac4be59a9.png)

In case of this plot, we sample and match the row numbers around 1000.

```python
import databricks.koalas as ks
import pandas as pd

pdf = pd.DataFrame({'a': [1, 2, 3, 4, 5, 6, 7, 8, 9, 15, 50, 100] * 100})
kdf = ks.DataFrame(pdf)
kdf['a'].plot.area(colormap='Paired').figure.savefig("image4.png")
```

![image4](https://user-images.githubusercontent.com/6477701/63408340-c176c380-c429-11e9-8880-cc0fab13bfe2.png)

Partially addresses #665
HyukjinKwon added a commit that referenced this issue Aug 22, 2019
@HyukjinKwon
Add plot.line in Series (#671)
d9147dc 
This PR add series.plot.pie in Series.

Can be tested as below:

```python
import databricks.koalas as ks
import pandas as pd

pdf = pd.DataFrame({
          'a': [1, 2, 3, 4, 5, 6, 7, 8, 9, 15, 50],
      }, index=[0, 1, 3, 5, 6, 8, 9, 9, 9, 10, 10])

kdf = ks.DataFrame(pdf)
pdf['a'].plot.line(colormap='Paired').figure.savefig("image1.png")
kdf['a'].plot.line(colormap='Paired').figure.savefig("image2.png")
```

![image1](https://user-images.githubusercontent.com/6477701/63409929-11a35500-c42d-11e9-9ce1-f2e16881ee98.png)


In case of this plot, we sample and match the row numbers around 1000.

```python
import databricks.koalas as ks
import pandas as pd

pdf = pd.DataFrame({'a': [1, 2, 3, 4, 5, 6, 7, 8, 9, 15, 50, 100] * 100})
kdf = ks.DataFrame(pdf)
kdf['a'].plot.line(colormap='Paired').figure.savefig("image4.png")
```

![image4](https://user-images.githubusercontent.com/6477701/63409938-16680900-c42d-11e9-96b6-c5038a5412b1.png)

Partially addresses #665
HyukjinKwon added a commit that referenced this issue Aug 22, 2019
@HyukjinKwon
Add plot.barh in Series (#673)
0969855 
This PR add series.plot.barh in Series.

Can be tested as below:

```python
import databricks.koalas as ks

kdf = ks.range(10)
kdf.to_pandas()['id'].plot.barh(colormap='Paired').figure.savefig("image1.png")
kdf['id'].plot.barh(colormap='Paired').figure.savefig("image2.png")
```

![image1](https://user-images.githubusercontent.com/6477701/63411569-c68b4100-c430-11e9-9d88-9f1113663def.png)

In case of this plot, we sample and match the row numbers around 1000.

```python
import databricks.koalas as ks

ks.range(1001)['id'].plot.barh(colormap='Paired').figure.savefig("image3.png")
```

![image3](https://user-images.githubusercontent.com/6477701/63411580-cc812200-c430-11e9-945b-0f74305c2507.png)


Partially addresses #665
@HyukjinKwon
Copy link
Member Author

We will track it in #293

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@HyukjinKwon