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 |