#python spreadsheet

[spreadsheetautomation]

Tips for Writing Python Code

Python is a versatile programming language with many purposes. It's the go-to language for building dynamic websites and feature-rich software. However, it can also be a valuable tool in data analysis, spreadsheet automation and more.

It can take time to learn Python and harness its true potential. To help you get there, here are a few tips for writing Python code.

Take Advantage of Sets

In Python, sets are unordered collections of data. They have no duplicate content. Therefore, learning to use sets is a great way to perform calculations. Many analysts use sets instead of traditional lists when they only need unique values.

Try converting lists to sets with curly brackets. When you create a set, Python can make internal optimizations. It's also a great way to calculate intersections and differences between multiple sets.

Use Generators

Let's say that you have a list with thousands of items. Your goal is to calculate the sum of those items. This is a common task for analysts, but you may also use it for software development. Whatever the case, there are multiple ways to approach this task.

The most straightforward is to perform the calculation with the list. However, doing so can lead to disastrous memory issues.

One game-changing workaround is to use generator comprehension. These comprehensions are similar to list comprehensions and have the same syntax. However, they use parentheses instead of brackets.

The generator comprehension generates one item at a time. As a result, it uses significantly less memory than a list.

Simplify Your If Statements

"If" statements are the backbone of Python and can come in handy for virtually every application of the language. For the most part, using these statements is easy. But when you have to apply them to a long list of items, it can become cumbersome and increase the risk of errors.

One way to improve efficiency is to use an "if x in" list. You can apply this syntax to an entire list, saving you time.

Take Advantage of Automation

Our final tip is to use automation whenever you can. Python is a powerful language that helps many professions. But using it can be a hassle. AI-powered automation lets you take advantage of the language's best features while skipping the menial tasks. If you're an analyst, consider using spreadsheet automation. It's a game-changer that will let you avoid complicated workaround or waiting for IT support.

Transform your Python spreadsheets: click now to optimize your data like never before!

[pinkkop]

I've now posted my second weekly QL recap post and I'm honestly just really proud of myself. Not just that I've stuck to doing it but also that I've managed to make it something I might actually be able to keep doing because I've made it as easy as possible for myself. That way it's less likely that it'll start feeling like a chore or that it'll take up a lot of my time when I'd rather be talking about the shows than formatting a post.

So because I'm a nerd and I kinda wanna show off a little bit because I'm proud of what I've managed to make, let me tell you exactly what I've set up to make my weekly recap post.

The basis for the post is simple enough: an excel spreadsheet and a python script.

My Spreadsheet of BLs

The spreadsheet is based on My Watchlist on MyDramaList which I literally just do ctrl+A and copypaste into a sheet. This is then automatically compiled into a different sheet where I've made a better overview of all the shows I'm watching and have watched in the past.

Based on this I've set up the weekly overview in a separate sheet shown below

When I'm compiling my weekly recap I can then easily add any new information here.

For new shows I add the information below to the sheet

- MD Title (copied from MyDramaList overview sheet)

- Title (usually copy of MD title with minor edits)

- Site I'm watching the show on

- Tags I want to use for the show

- Episode nr. I'm starting the show on

I also make a banner for the show but I've found a good source for images so it doesn't take long most of the time.

I have to manually upload the banner for the first week but then for the second week a show is in the recap, I can add the HTML for the banner from the previous week's post to the sheet. That way the banner will just be automatically be added to the post every week after that.

Throughout the week I then write notes on each episode I watch into the sheet and before I make the actual post I add the order I want the shows to appear in on the post.

The Script is Where the Magic Happens

When I've finished filling out the spreadsheet for the week I go to my python script, change the week number in the script and run the script.

In the script I've taken the HTML code from my original recap post and set it up so the script fills the information from my spreadsheet for each show into the right places in the HTML code. Since I doubt you guys would find it riveting to look at my full script, here's a little snippet!

When I run the script it then prints out the HTML for the post which I can insert into a new post on tumblr and voila, a weekly recap!!!

I do then have to go through the text for each show and add breaks and spellcheck because that's easier to do here than in the excel cell where I write the notes to begin with. If I have any overall notes or any new banners I have to add, then this is also when I'd do it.

I'm sure there are things you could set up in a better way but this works for me and reduces the amount of time I have to set aside every week for creating the post by a lot. It just makes it easier for me to share my thoughts in a way that's nice to look at without having to spend a ton of time formatting a post each week.

Hope this didn't take away any of the magic behind my posts but just gave a cool insight into the things you can do to make recurring posts easier to make.

Any questions or comments are welcome!

Side note: if you use tumblr on the mobile app and notice that any of the lines with "Episode x of x || Watching on:[site]" are split into two lines, let me know!

That line was surprisingly the hardest to make look the way I wanted because the width of posts and look of text types change depending on whether you're on desktop or the mobile app.

[readingloveswounds]

i will not apply to the graduate assistant position i will not apply to the graduate assistant position i will not

[cheshire-castle-library]

I'm terrified I'm gonna leave this little bastard in my code when I put it in my dissertation appendix, but a little part of me hopes I get away with it~

[analyticsshiksha]

Mastering Data Analytics: Explore the leading tools professionals rely on to unlock insights. From versatile platforms to specialized software, discover the top choices for effective data analysis.

Stay tuned for the next post!

know more: https://www.analyticsshiksha.com

[slunch]

re: generative art post

i always really struggled with processing and p5js, but i found Drawbot to be easy and pretty powerful (and i think python is fun)! It’s free and open source, only down side is i think they only have a mac client atm :/

oh thanks for the rec, it looks pretty easy to pick up but i think i'm gonna go the sicko route and try out nannou tonight since I've been trying to pick up Rust this year. we will see

[relto]

while trying to figure out how to copypaste values in the excel sheet, i came across at LEAST one person who was like "well just write the values into an array and iterate over the cells". yes thats such a great idea, i have multiple sheets with over 10k cells that need attention each, its totally not going to take an hour for a simple operation

[procurement-insights]

Spreadsheets, Procurement, MS Python and my 18-Year-Old Daughter's Boyfriend

Microsoft Adds Python Programming to Excel - Is procurement ready for the spreadsheet evolution?

To any parent, the oldest child in your family has a special place in your heart. As a father, besides being the firstborn, a daughter adds a dimension of pride and protective love. Once your “little girl” reaches the dating age, you tend to become a little overprotective to the point that you show every potential suitor the shovel and bag of lye that you keep in your vehicle trunk as a “gentle”…

[spreadsheetautomation]

What is Python Automation?

In the rapidly evolving world of technology, automation stands as a cornerstone, significantly enhancing efficiency, accuracy and productivity in various domains. At the heart of this transformation lies Python automation, a powerful approach to scripting and automating repetitive tasks that otherwise consume valuable time and resources.

The Essence of Python Automation

Python automation leverages the simplicity and versatility of the Python programming language to create scripts that perform tasks automatically. This can range from data analysis, file management and network configuration, to web scraping. The beauty of Python lies in its extensive libraries and frameworks that cater to different automation needs, making it accessible to both beginners and seasoned developers. Its syntax is clear and concise, reducing the complexity of writing automation scripts and making the process more intuitive.

Automating Excel Using Python

One of the most practical applications of Python automation is managing and manipulating Excel files, a task known as "automating Excel with Python". This involves using libraries such as Pandas and OpenPyXL to read, write and modify Excel spreadsheets without the need for manual input. Automating Excel using Python not only speeds up data processing tasks but also minimizes errors, ensuring that data management is both efficient and reliable.

In workplaces where Excel is a staple for reporting and data analysis, this aspect of Python automation proves invaluable. It allows users to automate data entry, formatting and even complex calculations, turning hours of manual work into a few minutes of script execution.

Conclusion

Python automation is transforming the landscape of digital workflows, offering scalable and efficient solutions to mundane tasks. From web development to automating Excel with Python, its applications are vast and varied, catering to the needs of a wide range of industries. As we move forward, the role of Python in automation is set to grow, highlighting its importance in driving productivity and innovation in the digital age.

Read a similar article about Python for healthcare here at this page.

[saltycharacters]

[ID: Digital and traditional art of a standard morph ball python named Udon. The 1st image features drawing studies, where Udon is carefully referenced from accompanying photos several times. Following this is a more cartoonish depiction of her drawn in Posca markers, one from afar and the other up close. She’s wearing a little santa hat, green bow, and has some snowflakes surrounding her. End ID]

-

Udon!!!!!!!!

-

Don't forget, help Palestine:

-> arab.org <- Click once a day for free

-> gazaesims.com <- Instructs how to donate esims

-> gazafunds.com <- Randomly selects a fundraiser for you to support

-> Fundraiser spreadsheet <- Lists Gazan fundraisers

-> Operation Olive Branch Spreadsheet <- Lists other ways to support

-> Resource link google doc <- Has tons of information and links

[ipso-faculty]

A review of intersex/intergender flag mashup techniques

I really like it when I can figure out what a new pride flag means just from my knowledge of other flags, and I know I'm not alone on this. For example, here are some flags other people have made that I could immediately figure out were <thing> plus intersex:

So, I've been thinking about how we as intersex flag creators can create hybrid flags in consistent way. I'm most motivated to figure out a recipe for intergender flags: genders that are connected to being intersex.

I assembled a spreadsheet of 66 gender flags, and wrote a Python script to take my csv file, parse it, and use the drawsvg library to draw the different flags in different ways. And then I stared at the results, showed them to friends, and discussed what would be both reliable in terms of producing clear, decent-looking results. (A subset of the results are under the keep reading cut.)

In this post I'm gonna review five mashup techniques that I automated and talk about advantages/disadvantages to each. But first a TLDR: adding yellow border stripes is a simple and reliable way to make an intersex-hybrid flag that is now my favourite (and recommended) way to make a new intergender flag.

For example, here's the interfluid flag (genderfluid in a way that is specifically intersex):

***

Method 1: put a ring on it - advantages: simple to do, simple to understand - disadvantages: incredibly dependent on how well the ring colour works with background stripes, and the number of stripes. Would very roughly estimate only ~20% look decent.

Here's a subset of the results. Some, like genderfaun, look nice, but most look awkward:

A yellow ring is even worse:

I think the purple ring has a bit of potential, but I think it's not really viable for being used as a consistent, procedural way to make intergenders. ***

Method 2: stick a belt on it - advantages: already used for some existing mashups - disadvantages: some other genders are doing similar things, like voidpunk, and a white belt has been used by tons of groups for their mashups (e.g. neurogender).

It looks better than the ring alone, but I was still kinda underwhelmed because of how much it depends on the background stripes to not clash. Very roughly I'd say about 40% of the total results look good. Again, here's genderfae through paragender for comparison:

Using a purple belt helps in some cases but makes for some visually busy results:

The purple ones make me think of pokéballs. Again, there are some nice looking ones, but the effect over the whole group was underwhelming. ***

Method 3: inset into the ring - advantages: it's the most clearly "intersex plus X" - disadvantages: hard to read flags where the stripes are similar to each other; might clash with ring colour

When zoomed out like this the results aren't always super easy to read, but overall I'd say this is a reasonably reliably method - very roughly 60% of the results look good to me.

Playing with lightness and contrast on the inset flag likely would improve that number, but my goal here is to compare methods without tweaks.

Insetting into the intergender flag has similar results:

Method 4: add intersex-coloured stripe to the middle - advantage: seems like it would be simple - disadvantage: yellow middle stripe used for pansexual mashups; purple stripe is used in a bunch of of existing mashups - also disadvantage: turns out to actually be complicated in how to do it. Many flags have an odd number of stripes, not all flags have equal-length stripes, etc. I got buggy results on a whole bunch of flags like hijra and hypergirl and honestly if it takes dedicated debugging to fix it's probably too complicated.

When the original flag has an odd number of stripes, I doubled the original middle stripe up and this only works if there's a symmetry to the flag and all the stripes are of equal size.

The results are kinda busy. It looks good to my eyes very roughly 1/8 of the time (~12%) (I did an alternate version where I doubled the purple stripe around the original middle stripe and it's way worse.)

Purple stripe:

Yellow stripe looks less busy but more confusing:

Method 5: add border stripes with intersex colours - advantages: simple - disadvantages: maybe not as obviously intersex

I honestly didn't expect to like this one, but it has turned out to be my favourite. It works really reliably, like ~90% of the time, and it's distinctive.

Surprisingly, using purple gives a really different vibe. It kinda makes me feel claustraphobic:

Method 6: change the colours

This one I don't have automated results to share (at least not yet). Right now there are flags like how ultergender recolours the trans flag, that could serve as a template for recolouring.

This is much more complex computationally - I spent a bunch of time playing around with different colourspaces (HSV, LCH, oklab, okLCH) to try to do this automatically and have concluded that this actually a difficult computational problem and not feasible as a widescale recipe.

Part of why the ultergender recolouring works is there are just two colours to recolour. How should one recolour the genderfluid flag? The demigender flag? It's possible to create a convention but not something I'm up to this moment.

I think recolouring is better suited to creating entirely new identities (like ultergender) rather than intergenders that are "<gender> but in an intergender way". ***

Discussion

My goal in all of this has been to try and identify some reliable recipes for creating hybrid flags particularly for intergenders.

My entirely subjective and imprecise estimates of how reliably each method yielded a decent-looking result were: 1. Add yellow border: ~90%-ish 2. Inset: ~60% 3. Belt: ~40% 4. Ring: ~20% 5. Add middle stripe: ~1/8-ish

I was honestly surprised at how much I liked the yellow border method and the friends I've shown it to so far have liked it as well!

I'd like to propose adding yellow border stripes as a recipe for creating intergender flags. This is already in use for interfluid (genderfluid in a specifically/uniquely intersex way):

Indeed, it's the only one of the mashup functions I wrote that yields something for genderfluid that I actually like:

Extrapolating, here are examples of some gender coinings that I think would work: Interdemigender: demigender in a specifically/uniquely intersex way and/or demigender in a way linked to being intersex/intergender

Intervaguegender: vaguegender in a way that is specifically intersex, such as in a way that is connected to being intersex (i.e. one's gender is vague not just for being neurodivergent but also intersex)

I think it works well! I hope you like it! Let me know if you have any feedback. If there are other mashup techniques I didn't think of, let me know. :)

[foxeswithsweaterson]

Fuck it. Python time.

Sometimes I think I'm not that neurodivergent, and then I remember that my favourite way to play Pokémon is with multiple spreadsheets open at all times.

[corrodedcoffinfest]

Where the Wild Things Are Masterlist

Thanks to those of you who got wild over here at @corrodedcoffinfest! Everyone who participates in any way help make these events what they are.

This event had 6 total entries from 5 unique participants: 5 Fics, 1 Pieces of Art & 0 Other Works were submitted.

I've updated the big spreadsheet with these newest entries, bringing our current total from all events to 392!

And don't forget to check out our ao3 collection!

Submissions: Fic

i want you to love me like my parrot does, honey by @thisapplepielife | Word Count: 3000 | Rating: T | POV: Eddie | Pairing: Steddie | CW: Language, Fade to Black Sex | Tags: Modern AU, Flirty Flirting, Mutual Attraction, Getting Together, Animal Shelter Worker Steve Harrington, Exotic Animal Foster Eddie Munson, Annoyed Roommate Gareth Jones

Baby Maria by @mugloversonly | Word Count: 1314 | Rating: G | POV: Eddie | Pairing: Eddie Munson/Reader | CW: None | Tags: A Virginia Possum is found

Not In His Nature by @thisapplepielife | Word Count: 3000 | Rating: T | POV: Eddie | Pairing: Steddie | CW: Language, Recovering From Injuries | POV: Eddie | Relationship(s): Steddie, Eddie & Corroded Coffin, Steve & Dustin | Tags: Bigfoot Eddie, Steve "I've Got Latent Monsterfucker Tendencies" Harrington, Mix and Match and Made Up Lore, Hawkins is Fucking Weird, We All Know That, Canon Divergence, Set Between S3 & S4

Untitled by @keaganz | Word Count: 2410 | Rating: T | POV: Eddie | Pairing: Harringrove, end game Metalsandwich | CW: some swearing | Tags: Upside-Down, S4, Canon divergence, Billy and Robin are platonic soulmates, unreliable narrator because author has a migraine, Demo!Dog Chomp, Steve in the Upside-Down, fade to black implied sex, Eddie has a bisexuality crisis at the worst time, stancy mentioned

stripes by @steddieas-shegoes | Word Count: 954 | Rating: T | POV: Steve | Pairing: Steddie | CW: brief mention of euthanizing an animal but it doesn’t happen | Tags: established steddie, famous corroded coffin, crack treated seriously, Steve is in charge of them but you can decide how

Submissions: Art

Freak with a ferret & Jeff with a tarantula // Gareth with a snake & Eddie with a raccoon by @alicetallula | Medium: Art | Details: Done using ink pens, colored pencils, gel pens, graphite pencils, alcohol marker, acrylic paint pens and Photoshop for the background, t-shirts graphics, the hairs on the tarantula and the Freak's freckles, the scales on the gold python and Gareth's freckles

[n0phis]

what's up with the creature counterparts of your ocs? that seems rlly interesting....

im not 100% sure how to answer this, i wasnt sure whether it was in reference to pets, canon/more Creature Coded Features present in some aus (explained in another ask! eyeball emoji)

BUT!!! we do actually have specific animals associated with all characters! they actually started out being referred to as animals before they had names. worm and i have animal coded these cretins so fucking hard specifically rook, jasper and morgan have very heavy Animal Exploration with like. several different things worm and i have gone 'oh theyre so x-coded' about. BUT the strict list of Animal Starting Points is

lyra - lynx vic - wolf finn - ferret morgan - mink rook - pigeon nedward - buzzard ajax - bear jacob - badger adam - hyena and there are some exceptions (and a lot of less explored characters i havent listed here)! jasper was given an association later on, mostly housecat but sometimes i feel like he's Really ball python coded. sam doesn't really have one, we have one whose animal is simply listed as 'chuck' in the spreadsheet, and there's also Devil From The Bible who is simply doing his own thing

[analyticsshiksha]

Unlock career opportunities with these essential data analytics skills! Learn what employers are looking for and position yourself for success.

Stay tuned for the next post!

know more: https://www.analyticsshiksha.com

[no-stupid-questions-official]

Hello! I’m looking to pay someone to put together a Minecraft modpack for my partner and I. Where can I go that is best suited for finding someone to do this? More detailed information below:

I’ve organized a list of the mods I am interested in in a spreadsheet noting the following information:

- Name

- Creator

- Type (mod, resource pack, etc.)

- Available Format (Forge, Fabric, both, etc.)

- Most Recent Version Compatibility (ex. 1.21.4)

- Category (ex. World Gen)

- Subcategory (ex. Structures)

- Link

- Description (a few sentences copied and pasted from the page)

The total list contains about 370 items, but many are duplicate versions in different formats. If I were to only use Fabric items, there would be about 210 available, and if I were to use Forge items, there would be about 310 available. I would really like to find a way to use both Fabric and Forge items if possible as there are many mods I am extremely interested in that do not have alternative formats. Additionally, this list comprises every mod I could find that I thought we would be interested in. I am sure several mods may be redundant or some may be incompatible, but I have virtually zero experience working with mods and modpacks so I am uncertain as to which ones would be categorized as such. I can update the list to reflect prioritized preferences if that is helpful, but I would also appreciate any advice or input you may have on which ones to keep or others you could suggest. I also tried to include required compatibility mods as I worked through each item but may have missed some.

Through the power of ADHD hyperfixation I was able to put this list together, but my schedule is generally incredibly full from school and work. I will be unlikely to have the time or energy to learn the coding necessary to put a well-functioning modpack together. Besides, if I’m going to learn any coding, I’m going to learn Python as that is most applicable for my field.

As such, I’m really hoping to find someone with knowledge or experience in Minecraft modding and modpack development to work on the project for me, and I am more than happy and able to pay for it.

We can discuss rates privately as I am unfamiliar with the time commitment associated with these kinds of projects, but please trust that I intend to pay fairly and generously! This is a huge help for me and I deeply appreciate your time and dedication in your work.

Please reach out if you are interested! I am most available to discuss in the late afternoon or evening (Central Time).

TL;DR Where can I find someone I can pay to develop a modpack for Minecraft?

-