Category: ব্লগ । Blog

ব্লগ । Blog

Oracle Stored Procedure: Create a simple stored procedure

Ref: https://docs.oracle.com/database/121/LNPLS/create_procedure.htm#LNPLS01373

Spearman Correlation Coefficient and Graph Mining

#!/usr/bin/env python coding: utf-8 # 3rd Model: Deepgraph CNN: Stock Price Prediction using DeepGraphCNN Neural Networks. It includes GCN layers and CNN layers. I have added an MLP at the last layer to predict stock prices. # # Input graphs were created for spearman, Spearman, and Kendal Tau correlations/coefficients from historical stock prices. Also, another …

Continue reading

Python/ML Correlation Coefficients

df_s_transpose_pearson = df_s_transpose.corr(method = ‘pearson’, numeric_only = True) df_s_transpose_pearson # Pearson Correlation Coefficient df_s_transpose_pearson = df_s_transpose.corr(method = ‘pearson’, numeric_only = True) df_s_transpose_pearson Pearson Correlation Coefficient based Adjacency Graph Matrix df_s_transpose_pearson[df_s_transpose_pearson >= 0.5] = 1 df_s_transpose_pearson[df_s_transpose_pearson < 0.5] = 0 df_s_transpose_pearson Create a Graph import networkx as nx Graph_pearson = nx.Graph(df_s_transpose_pearson) before the above step do: …

Continue reading

Library Import in Python for ML/Graph ML

import libraries import os import pandas as pd import math Import Libraries for Graph, GNN (Graph Neural Network), and GCN (Graph Convolutional Network) import stellargraph as sg from stellargraph import StellarGraph from stellargraph.layer import DeepGraphCNN from stellargraph.mapper import FullBatchNodeGenerator from stellargraph.mapper import PaddedGraphGenerator from stellargraph.layer import GCN Machine Learning related library Imports (Tensorflow) from tensorflow.keras …

Continue reading

C# Thread-Safe Concurrent Collections

C# Concurrent classes are provided through System.Collections.Concurrent Concurrent classes: for thread-safe operations i. e. Now multiple threads can access the Collections without creating problems Concurrent classes: BlockingCollection ConcurrentBag ConcurrentStack ConcurrentQueue ConcurrentDictionary Partitioner Partitioner OrderablePartitioner

Core building blocks across Javascript, PHP, C++, Java, Python, and Ruby

Core building blocks across Javascript, PHP, C++, Java, Python, and Ruby: Ref: https://codesensei.medium.com/core-building-blocks-and-which-programming-language-to-study-first-446977d119a8

K-Means Clustering

Click on the images to see them clearly #!/usr/bin/env python coding: utf-8 In[1]: k-means clustering from numpy import unique from numpy import where from sklearn.datasets import make_classification from sklearn.cluster import KMeans from matplotlib import pyplot import numpy as np import pandas as pd import seaborn as sns import matplotlib.pyplot as plt get_ipython().run_line_magic(‘matplotlib’, ‘inline’) import pandas …

Continue reading

C# Application using VS Code

You need C# Dev Kit. .Net Install Tools (.Net Runtime Install Tools), .Net SDK, and extensions that these extensions also depend on. Then >.net option will give you the project create, open, build or similar features – Check Image below) Having Visual Studio is the best option (and in Windows Environment under VM (Parallels or …

Continue reading

Oracle: Error management and exception handling in PL/SQL

Raise Error in Oracle RAISE VALUE_ERROR; Raise Application Error in Oracle Create custom exception and raise it. Handle Exception You could also insert into error log table and RAISE Reference: https://blogs.oracle.com/connect/post/error-management

UML Collaboration Diagram

"Collaboration diagrams (known as Communication Diagram in UML 2.x) are used to show how objects interact to perform the behavior of a particular use case, or a part of a use case. Along with sequence diagrams, collaboration are used by designers to define and clarify the roles of the objects that perform a particular flow …

Continue reading