Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »

Welcome to Software Development on Codidact!

Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.

Activity for mcp‭

Type On... Excerpt Status Date
Edit Post #288068 Post edited:
Revert to edit #4
6 months ago
Edit Post #288883 Post edited:
Add headers
9 months ago
Edit Post #288883 Initial revision 9 months ago
Question Can pandas be used as a database backend for persistent storage?
Question What is the current state of the art database app? How does it compare to SQL? Can pandas be used in place of either? If not, is there something that bridges the gap between SQL and pandas or the current state of the art? Context I have become proficient in pandas and have come to...
(more)
9 months ago
Edit Post #288857 Post edited:
Remove duplicates in all methods for consistency and update timings
9 months ago
Edit Post #288857 Post edited:
Fix grammar and reference Tried
9 months ago
Edit Post #288857 Initial revision 9 months ago
Answer A: Remove entries by two-column ID everywhere, that meet a condition somewhere
Answer After re-encountering this problem and searching for a solution with a less generic "pandas check if column pair is found in other df" (forgetting I had previously encountered this problem altogether), I found some inspiration that led me to a solid solution. It is fastest, and most c...
(more)
9 months ago
Comment Post #288074 The problem with this answer is that it will remove cells in every die, when it should only remove cells identified within that die. With your answer, if I find that die 1, cell 9 is bad, I will also be removing die 2, cell 9, which may not be bad.
(more)
9 months ago
Edit Post #288068 Post edited:
Make title more accurate
11 months ago
Edit Post #288068 Post edited:
Remove redundant "this"
11 months ago
Edit Post #288068 Post edited:
Switch order of sanity check for more sane check
11 months ago
Edit Post #288068 Initial revision 11 months ago
Question Remove entries by two-column ID everywhere, that meet a condition somewhere
MWE ```py import random import pandas as pd from itertools import product random.seed(12345) dies = [1, 2] cells = list(range(10)) currents = [100, 200, 300] dcc = list(product(dies, cells, currents)) resistances = random.choices(range(250000 + 1), k=len(dcc)) df = pd.DataFra...
(more)
11 months ago
Comment Post #287884 It's a good question. I would expect there to be a parameter for this in the `mean()` function.
(more)
about 1 year ago
Edit Post #287884 Initial revision about 1 year ago
Question How to compress columns of dataframe by function
Problem How can I compress each column of a dataframe to the output of a function (i.e., mean), preserving columns? MWE ```py import pandas as pd data = {"A": [1, 2, 3, 4], "B": [5, 6, 7, 8]} df = pd.DataFrame(data) ``` ``` A B 0 1 5 1 2 6 2 3 7 3 4 8 ``` Desired...
(more)
about 1 year ago
Comment Post #287514 Built-in to pandas. Pandas tends to be feature complete with respect to R. [Here is the function documentation in R](https://search.r-project.org/CRAN/refmans/goeveg/html/cv.html).
(more)
over 1 year ago
Edit Post #287509 Initial revision over 1 year ago
Question Built-in way to compute coefficient of variation in pandas
Background The coefficient of variation is: > defined as the ratio of the standard deviation to the mean Question Is there a built-in function for this? Tried I know I can do `df.std() / df.mean()`.
(more)
over 1 year ago
Edit Post #286768 Post edited:
Add update dates
over 1 year ago
Edit Post #286768 Post edited:
Update
over 1 year ago
Comment Post #287314 ```py filename = "bad_dir" raise FileNotFoundError(filename) ```
(more)
over 1 year ago
Edit Post #287312 Post edited:
Make question findable
over 1 year ago
Edit Post #287312 Initial revision over 1 year ago
Question How can I provide additional information when raising an exception?
Suppose I have some code like: ```py filename = "baddir" print(f"File not found: {filename}.") raise(FileNotFoundError) ``` When the exception isn't caught, the stack trace is printed at the end of the output, right as the program aborts. The `print`ed message could be far above this and is...
(more)
over 1 year ago
Comment Post #286768 Not sure if this was always there, but the drop down to the right of your account lets you jump to other topics! (Would still be nice if "Communities" was clickable.)
(more)
over 1 year ago
Comment Post #286768 Too cool! I can now subscribe to other users!
(more)
over 1 year ago
Comment Post #286789 I meant how do you figure it wouldn't require much manual formatting.
(more)
over 1 year ago
Comment Post #286789 Either way it's going into latex, .png or table. I'm open to both, but only a solution that lets me export to that format without me manually re-entering data.
(more)
over 1 year ago
Comment Post #286789 How do you figure?
(more)
over 1 year ago
Comment Post #286791 Nice, this also works if I store the plot in a variable for saving: ```py plot = df.plot.bar() plot = plot.axvline(x=2.5, ymin=0, ymax=1) plot.get_figure().savefig("busy_bar.png") ```
(more)
over 1 year ago
Edit Post #286789 Post edited:
Add notes header
over 1 year ago
Edit Post #286789 Post edited:
Add note about legibility
over 1 year ago
Edit Post #286789 Post edited:
Add output image
over 1 year ago
Edit Post #286789 Initial revision over 1 year ago
Question How to plot table from pandas dataframe
MWE ```py import pandas as pd import numpy as np import matplotlib.pyplot as plt df = pd.DataFrame(np.random.rand(9, 4), columns=['a', 'b', 'c', 'd']) df.plot.bar(table=True) # don't want plot, just want table df.plot.table() # what I would hope plt.show() ``` Busy Bar with Table Q...
(more)
over 1 year ago
Edit Post #286768 Post edited:
Add vimium note
over 1 year ago
Comment Post #286780 https://powerusers.codidact.com/posts/286781
(more)
over 1 year ago
Comment Post #286780 Because this is so manual, I might consider post-processing in Gimp or similar.
(more)
over 1 year ago
Comment Post #286780 Sounds promising, can you post output?
(more)
over 1 year ago
Edit Post #286776 Post edited:
Remove support tag now in right tab (Q&A)
over 1 year ago
Edit Post #286776 Post edited:
Add python tag
over 1 year ago
Edit Post #286776 Initial revision over 1 year ago
Question How to add vertical lines for visual separation in pandas plot
MWE ```py import pandas as pd import numpy as np import matplotlib.pyplot as plt df = pd.DataFrame(np.random.rand(9, 4), columns=['a', 'b', 'c', 'd']) df.plot.bar() plt.show() ``` Busy Bar Graph Question How do I add separating vertical lines between groups? Say these are groups o...
(more)
over 1 year ago
Edit Post #286768 Post edited:
Add like
over 1 year ago
Edit Post #286768 Post edited:
Make update clear and add other request
over 1 year ago
Edit Post #286768 Post edited:
Add user bookmarking request
over 1 year ago
Comment Post #286768 Yes the solid "click, unclick" is something I find very pleasing! I like being deliberate and being guided towards explicit actions. Brings confidence and eagerness to my workflow. For big threads, for sure, take the user to the full context. For one or two comment threads, which is what I've enco...
(more)
over 1 year ago
Edit Post #286768 Post edited:
Add url impression
over 1 year ago