Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
phpc.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A server for PHP programmers & friends. Join us for discussions on the PHP programming language, frameworks, packages, tools, open source, tech, life, and more.

Administered by:

Server stats:

798
active users

phpc.social: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.6

#excel

5 posts5 participants0 posts today
Public
Francis Mangion (M)

Python Projects Community:

#Excel vs #SQL vs #Python [Facebook]:

facebook.com/share/p/1Gb5xwQgu

Task Excel Vs SQL VS Python Excel Load Data file Open File SELECT FROM table_nane; Python (Pandas) B10, SELECT Columns table Use column Letters read_csv("file.c Short df(df[ column'] Data SELECT colunnl, colunn2 100] Sort Aggregate ORDER Pivot Table DESC; colu GROUP Average Mean dept; =AVERAGE(B2:B100) aggo B100) Remove VG(salary) Data salary' Renove FROM nean( Join Tables sun() DISTINCT colunn table; LODKUP XLOOHUP FROM =B2 column JOIN ,drop_duplicates() df2, salary, salary*Đ. Manually 'bonus'] Missing Data colunn FROM table; IF(ISBLANK(A2), "N/A", Export File Save NULL, COALESCEO inplace=True) Visualization Insert or Charts SSMS) df.dropnaC) Not native; use f.to_csv("output. ,index=False) .plot(kind=" 'bar'), natplotLib
www.facebook.comTask Excel Vs SQL VS Python Excel Load Data file Open File SELECT FROM table_nane; Python (Pandas) B10, SELECT Columns table Use column Letters read_csv("file.c Short df(df[ column'] Data SELECT colunnl, colunn2 100] Sort Aggregate ORDER Pivot Table DESC; colu GROUP Average Mean dept; =AVERAGE(B2:B100) aggo B100) Remove VG(salary) Data salary' Renove FROM nean( Join Tables sun() DISTINCT colunn table; LODKUP XLOOHUP FROM =B2 column JOIN ,drop_duplicates() df2, salary, salary*Đ. Manually 'bonus'] Missing Data colunn FROM table; IF(ISBLANK(A2), "N/A", Export File Save NULL, COALESCEO inplace=True) Visualization Insert or Charts SSMS) df.dropnaC) Not native; use f.to_csv("output. ,index=False) .plot(kind=" 'bar'), natplotLibDifference between Excel vs SQL vs Python✅
Public *
Karl Voit :emacs: :orgmode:

The Microsoft-Dilemma - #Europe as a #Software Colony (43min)
kolektiva.media/w/cbb9f78a-970 (or
youtube.com/watch?v=duaYLW7LQv if you don't mind YT using/stealing your data)

This is how the #EU is paying a secret number of Millions to #Microsoft in order to stay less secure, more dependend, less self-empowered, and more corrupt.

And this was known even before the US went totally crazy, risking our future big time.

So let's change and take back control using #FOSS software and open standards for true competition and actually according to our own rules for a change.

PeerTubeThe Microsoft-Dilemma - Europe as a Software Colony | Full DocumentaryBy solarpunk
#Windows#Word#Excel
Public
Christian Drumm 🇪🇺🧗🚵

Does anyone know if there’s already a petition or initiative in #Germany ot the #EU calling on higher education institutions (Universitäten and Fachhochschulen) to switch to #opensource software?

Specifically, I’m looking for efforts to stop the use of #Microsoft (Windows, Outlook, Exchange, MS Office, etc.) in administration and to move away from teaching tools like #Word,#Excel, or #visualstudio.

I'm looking for something similar to this:
👉 openpetition.de/petition/onlin

openPetitionAppell an die Hochschulrektorenkonferenz zur Nutzung sozialer Medien - Online petitionWir fordern die Hochschulen in Deutschland auf, ihre Accounts bei X (vormals Twitter) baldmöglichst still zu legen. Die Präsenz bei X/Twitter wird aufgrund der dort betriebenen Desinformation und politischen Hetze nicht dem Aufklärungsanspruch der Hochschulen gerecht. Gleichzeitig sollten Präsenzen auf Mastodon (https://de.wikipedia.org/wiki/Mastodon_(Software)) und anderen Servern im Fediverse (https://de.wikipedia.org/wiki/Fediverse) aufgebaut werden, deren dezentrale und moderierte Gestaltung
#digitalsouverenity
Public
Vera :bike_verified:

Hallo #excel|Menschen, was ist das denn? Die Kollegin weiß natürlich nicht was sie getan hat, war damit dann aber komplett lahmgelegt und konnte nichts mehr tun. Mit einmal per win + D minimieren war dann wenigstens wieder der Cursor "frei" und sie konnte speichern.
Beim Speichern hat's dann was von Zirkelbezug gesagt. (Ich war nur am Telefon, habe nichts davon gesehen)

Public *
pvergain (framapiaf)

github.com/gristlabs/grist-cor

Grist is the evolution of #spreadsheets.

The grist-core repo is the heart of Grist, including the hosted services offered by Grist Labs, an NYC-based company 🇺🇸 and Grist's main developer.

The French government 🇫🇷 organizations ANCT Données et Territoires and DINUM (Direction Interministérielle du Numérique) have also made significant contributions to the codebase.

- github.com/gristlabs/grist-cor

Le texte : The grist-core repo is the heart of Grist, including the hosted services offered by Grist Labs, an NYC-based company 🇺🇸 and Grist's main developer. The French government 🇫🇷 organizations ANCT Données et Territoires and DINUM (Direction Interministérielle du Numérique) have also made significant contributions to the codebase. à l'adresse suivante: https://github.com/gristlabs/grist-core#:~:text=the%20grist-core%20repo%20is%20the%20heart%20of%20grist
#grist#excel#databases
Continued thread
Public
stateful being

the table thing ties back into into #vestal, the binary patcher for old soundwares (codeberg.org/unspeaker/vestal - that one isn't passing its ci yet, baaad code, baaaaaad developer!)

that could sure use some interactivity, at least in development. would keep me focused.

it also ties back into #tek, whose entire thing is reimplementing #ableton's "#excel for music" schtick in a terminal, so, again, tables!

or, more properly, collapsible table-trees... not a new idea, more like a lost technology! 😁

Codeberg.orgvestal🏛️ relinks closed-source windows vst plugins into standalone linux jack devices💃
SearchLive feeds
About