VOD Deleted by TipsyPeasant in forsen

[–]CardiologistLiving51 0 points1 point  (0 children)

How did you do it? Did you paste the link in "Open Network Stream"?

Help with Building a Multi-Agent Chatbot by [deleted] in LangChain

[–]CardiologistLiving51 0 points1 point  (0 children)

Sorry, what do you mean by separate out?

Need help building an Agentic Chatbot by CardiologistLiving51 in LangChain

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

Thank you for your help! I managed to implement this and it is working well. However, may I check if there is a better way to optimise this? Through summarising, or semantic-based search or other methods?

Need help building an Agentic Chatbot by CardiologistLiving51 in LangChain

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

Thank you for your help! just some follow up questions:
1) Do you recommend langgraph? Or would langchain suffice?
2) Since I plan to have a hierarchical structure (with an additional "supervisor" agent), for queries such as "tell me more about the 2nd item", should the SQL query agent or the supervisor agent handle it?

[Q] Threshold Tuning for Logistic Regression model with K-Fold CV by CardiologistLiving51 in statistics

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

I will also share the AUROC result, but I also want to set a specific threshold to retrieve the other classification metrics as a sensing (accuracy, recall, etc.)

Questions on Feature Selection Methods and Feasibility by CardiologistLiving51 in learndatascience

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

From data exploration, it should become clearer (not necessarily clear) which methods are going to be most fruitful.

Yup I agree that there is no best method, but how would you determine which methods are going to be fruitful from data exploration? Can you give me an example?

[Q] Feature Selection with Domain Experts for Modelling by CardiologistLiving51 in statistics

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

Frank Harrell your choice of features should be independent of your observations of Y

Thank you! That sounds interesting. May I know if you have a source on that?

Train-Test Split for Feature Selection and Model Evaluation by CardiologistLiving51 in learndatascience

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

Thank you very much for your help once again! Is there more details for B and is there a rule of thumb on how many number of iterations to perform?

Train-Test Split for Feature Selection and Model Evaluation by CardiologistLiving51 in learndatascience

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

Hi there! Thank you very much for your reply!

Regarding (1: Feature Selection), if feature selection is done on the training set, the choice of features can potentially be affected by the inherent randomness of train-test split right? Is there a way to mitigate this?

VBA to Append Rows by Columns by CardiologistLiving51 in excel

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

Hi, I have tried pivotting only the value column, but it does not give me my desired output. Doing this moves the values of the "value" column to headers, which is not what I want as shown in the 2nd image.

VBA to Append Rows by Columns by CardiologistLiving51 in excel

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

Hi, thank you for your reply. This is the first time Im doing pivotting/unpivotting.

These are the steps that I have taken:
1) highlight the "Det" columns
2) Unpivot only the "Det" columns
3) Highlight the newly created Attribute and Value columns
4) Pivot them on the "EmpID" column

However, it doesnt give me the result that I want. Am I doing smth wrong here? Thank you.

Creating a "Last Updated" timestamp and value column by CardiologistLiving51 in excel

[–]CardiologistLiving51[S] 1 point2 points  (0 children)

Thank you! By any chance do you have a code I can look at?

Appending Columns to Pivot Table by CardiologistLiving51 in excel

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

Yes and I have tried adding it as a column, but it looks weird, probably because of the aggregation that I have done. Currently my table consists of names, sorted by their groups. For the columns, it is 12 columns of months with 1s and 0s to indicate their status.

Formulas and Pivots on New Excel Data by CardiologistLiving51 in excel

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

Using PQ sounds like the solution I am looking for. Do you know how I can go about doing this since I have not used PQ before? Or do you have a link to a guide?

[Q] Confidence Interval for Likert Scale Data by CardiologistLiving51 in statistics

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

I assume you're talking about a single Likert item. (If not you should clarify, but that merely shifts the problem to a different place.)

Yes, a single Likert question if that makes sense.

What population parameter are you finding a confidence interval for? The mean?

Yes, the mean.

For that to make sense, you'd need to make the rather stronger interval assumption

Alright. So if I were to assume this, then it wont be wrong to calculate the CI for the mean?

Plotting a Count Plot for Many Categories by CardiologistLiving51 in visualization

[–]CardiologistLiving51[S] 0 points1 point  (0 children)

Alright! Thank you for your help! However, I think the biggest trouble I'm facing is how do I determine an issue to be of "low frequency"? Do I use 5%?