excel functions for compiling data - vstack & hstack!

Published: 18 June 2023
on channel: Aasha tech

The functions `hstack` and `vstack` are commonly used in programming, especially in the context of arrays or matrices, to horizontally or vertically stack arrays or matrices, respectively.

1. hstack:
`hstack` stands for "horizontal stack."
It is used to concatenate arrays or matrices along the horizontal axis.
When you use `hstack`, the arrays or matrices should have the same number of rows, as you are stacking them horizontally.
For example, if you have two arrays `A` and `B` with dimensions `(m, n)` and `(m, p)` respectively, where `m` is the number of rows, `n` is the number of columns in `A`, and `p` is the number of columns in `B`, then `hstack` will return a new array with dimensions `(m, n+p)` that horizontally concatenates `A` and `B`.

2. vstack:
`vstack` stands for "vertical stack."
It is used to concatenate arrays or matrices along the vertical axis.
When you use `vstack`, the arrays or matrices should have the same number of columns, as you are stacking them vertically.
For example, if you have two arrays `A` and `B` with dimensions `(m, n)` and `(q, n)` respectively, where `m` is the number of rows in `A`, `q` is the number of rows in `B`, and `n` is the number of columns, then `vstack` will return a new array with dimensions `(m+q, n)` that vertically concatenates `A` and `B`.

In both cases, the resulting stacked array or matrix will have the appropriate shape based on the axis along which the stacking is performed. It's important to ensure that the dimensions of the arrays or matrices are compatible for stacking, otherwise, you may encounter errors or unexpected results.

These functions are commonly available in various programming languages and libraries, such as NumPy in Python, where they are used for array manipulation and data analysis tasks.

HOME PAGE LINK=   / @aasha_tech

PLAY LIST LINKS
1.MS EXCEL=   • MS EXEL
2.COMPUTER REALTED =   • COMPUTER REALTED VIDEOS
-------------------------------------------------------------------------------------------------------------------------
SOCIAL MEDIA OFFICIAL ACCOUNTS
INTAGRAM=https://www.instagram.com/uikeycreati...
TWITTER=  / lightuikey2

THANK YOU FOR WATCHING THIS VIDEO

On this page of the site you can watch the video online excel functions for compiling data - vstack & hstack! with a duration of hours minute second in good quality, which was uploaded by the user Aasha tech 18 June 2023, share the link with friends and acquaintances, this video has already been watched 68 times on youtube and it was liked by 6 viewers. Enjoy your viewing!

13,912

323