Python, Excel Individual Commands - Revision history

Bacchas at 18:29, 11 September 2020

2020-09-11T18:29:18Z

← Older revision		Revision as of 18:29, 11 September 2020
Line 5:		Line 5:
	fig.show()		fig.show()
	''' active_posts has the data, username is a column also messages posted'''		''' active_posts has the data, username is a column also messages posted'''
			==Sorting Data Output==
			'''Sorting in ascending order'''
			df.sort_values(by=['Brand'], inplace=True)

			'''Sorting in Descending order'''
			df.sort_values(by=['Brand'], inplace=True, ascending=False)

			'''Sort multiple columns'''
			df.sort_values(by=['Year','Price'], inplace=True)

	==[[#top\|Back To Top]] - [[Python\|Main Category]]/[[Python_Excel_Related\| Excel Category]]==		==[[#top\|Back To Top]] - [[Python\|Main Category]]/[[Python_Excel_Related\| Excel Category]]==
	[[Category:Python]]		[[Category:Python]]

Bacchas at 18:19, 11 September 2020

2020-09-11T18:19:06Z

← Older revision		Revision as of 18:19, 11 September 2020
Line 4:		Line 4:
	fig = px.pie(active_posts[['username', 'Messages posted']], values='Messages posted', names='username')		fig = px.pie(active_posts[['username', 'Messages posted']], values='Messages posted', names='username')
	fig.show()		fig.show()
	'' active_posts has the data, username is a column also messages posted''		''' active_posts has the data, username is a column also messages posted'''

	==[[#top\|Back To Top]] - [[Python\|Main Category]]/[[Python_Excel_Related\| Excel Category]]==		==[[#top\|Back To Top]] - [[Python\|Main Category]]/[[Python_Excel_Related\| Excel Category]]==
	[[Category:Python]]		[[Category:Python]]

Bacchas at 18:18, 11 September 2020

2020-09-11T18:18:55Z

← Older revision		Revision as of 18:18, 11 September 2020
Line 4:		Line 4:
	fig = px.pie(active_posts[['username', 'Messages posted']], values='Messages posted', names='username')		fig = px.pie(active_posts[['username', 'Messages posted']], values='Messages posted', names='username')
	fig.show()		fig.show()
	''' active_posts has the data, username is a column also messages posted''		'' active_posts has the data, username is a column also messages posted''

	==[[#top\|Back To Top]] - [[Python\|Main Category]]/[[Python_Excel_Related\| Excel Category]]==		==[[#top\|Back To Top]] - [[Python\|Main Category]]/[[Python_Excel_Related\| Excel Category]]==
	[[Category:Python]]		[[Category:Python]]

Bacchas: Created page with "==Creating a pie chart from data== import plotly.express as px ## pip install plotly fig = px.pie(active_posts'username', 'Messages posted', values='Messages posted', n..."

2020-09-11T18:18:41Z

Created page with "==Creating a pie chart from data== import plotly.express as px ## pip install plotly fig = px.pie(active_posts'username', 'Messages posted', values='Messages posted', n..."

New page

==Creating a pie chart from data==
import plotly.express as px
## pip install plotly
fig = px.pie(active_posts[['username', 'Messages posted']], values='Messages posted', names='username')
fig.show()
''' active_posts has the data, username is a column also messages posted''

==[[#top|Back To Top]] - [[Python|Main Category]]/[[Python_Excel_Related| Excel Category]]==
[[Category:Python]]