Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
nerdculture.de is one of the many independent Mastodon servers you can use to participate in the fediverse.
Be excellent to each other, live humanism, no nazis, no hate speech. Not only for nerds, but the domain is somewhat cool. ;) No bots in general. Languages: DE, EN, FR, NL, ES, IT

Administered by:

Server stats:

1.2K
active users

nerdculture.de: 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
LeonianUniverse😁

Does anyone know if it is possible to create a corolation chart in #Excel? I want to be able to agrogate some data that I've calculated in my head and be able to determine the average of different variables which I would use to get a clearer average for how many times an event occurs within a certain period of time. Sorry I have to be so vague,but this data is highly classified... at least to me and the person this data is meant for and I don't want a trace of it getting out.

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
Laurențiu Leahu-Vlăducu

As some of you might know, I'm a co-maintainer of the XLNT library (or rather the xlnt-community fork) for parsing Excel files (xlsx / xlsm formats).

Today I have an important announcement: 5 years after the previous release, XLNT 1.6.0 has been released! 🎉 😀 github.com/xlnt-community/xlnt

Dear community, we are very excited to release the first stable version of XLNT from the xlnt-community fork, and the first XLNT release since 5 years! This release has a HUGE number of fixes and i...
GitHubRelease XLNT v1.6.0 · xlnt-community/xlntDear community, we are very excited to release the first stable version of XLNT from the xlnt-community fork, and the first XLNT release since 5 years! This release has a HUGE number of fixes and i...
#xlnt#cpp#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 *
DesertFOX

So langsam schließen sich die letzten Lücken in meiner Sammlung antiker Windows- und Office-Disketten. Excel 3.0a lief als letzte Excel-Fassung noch original unter Windows 3.0 und war außerdem das erste mit einer grafischen Symbolleiste! Dieses unglaubliche Feature wurde damals auch noch groß auf der Verpackung beworben!

Hier ein perfektes Set der deutschen Vollversion mit 1.2MB, 5.25 Zoll KryoFlux Images. Natürlich wieder inkl. aller IMGs und sauberer JPG-Scans sämtlicher Datenträger:

archive.org/details/ms-excel_3

Viel Spaß und gute Nacht ihr Wahnsinnigen! 😉

Microsoft Excel 3.0 für Windows, die Schachtel.
Microsoft Excel 3.0a läuft unter Windows 3.0.
#RetroComputing#Excel#Office
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
POUJOL-ROST Mathias ✅

En ces temps où on parle de #souveraineté (notamment #numérique),
j'en viens *presque* à rêver que #Trump / #Musk nous sorte une phrase du genre :

"De toute façon vos comptes de réseaux sociaux sont hébergés chez nous [ie: aux USA], de même que vos #mails et documents #Word / #Excel, et parfois même vos #pensions de retraite sont largement composé de fonds ou d'actions d'entreprises US".

Provoquant ainsi une certaine "réalisation" (angliscisme) et une panique de notre #dépendance.

Public *
DesertFOX

Hatte gestern einen eigentlich ziemlich hässlichen 720K Diskettensatz in der Post. Den Dingern sah man ihre 35 Jahre doch schon ziemlich an, aber die Optik war in dem Fall nebensächlich, denn das Auslesen per KryoFlux war dann eine wirklich positive Überraschung. Alle Datenträger waren absolut perfekt lesbar!

Es handelt sich um die deutsche Vollversion von Microsoft Excel 2.1d. Diese Fassung von Excel wurde noch rein über MS-DOS installiert und lief auf Windows ab Version 2.x. Ziemlich historisch. Hier gibt es die kompletten Flux- und IMG-Images, sowie 300dpi Scans aller Disketten:

archive.org/details/ms-excel_2

Viel Spaß! 😉

Optisch ziemlich hässlicher Diskettensatz von Microsoft Excel 2.1.
#RetroComputing#Microsoft#Excel
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
ExploreLive feeds
About