Categories

## how to remove last column of an array in python

my Array size is unknow and I would like to remove the very last column a = np.array([[“A1″,”A2″,”A3”],[“B1″,”B2″,”B3”],[“C1″,”C2″,”C3”]]) I tried a[-1:] it deleted all rows except the last row and i tried a[:-1] it deleted the last row. how can I delete the last column?

Categories

## Rotation matrix and its powers

A is a rotation matrix in ${\mathbb{R}}^2$ by angle $θ=30°$. I know the matrix: $A= \begin{bmatrix} \frac{\sqrt{3}}{2} & -\frac{1}{2}\\\frac{1}{2} & \frac{\sqrt{3}}{2} \end{bmatrix}$ I can write $A$ to another form: $$A= \begin{bmatrix} \frac{\sqrt{3}}{2} \\ -\frac{1}{2} \\ \frac{1}{2} \\ \frac{\sqrt{3}}{2}\\ \end{bmatrix}$$ The question is how many of $A$‘s powers are linearly independent? So i have […]

Categories

## Fetch the state attribute from YAML using Cpp

I have the below YAML file.(example.yaml) test: – testA: – state: off – name: a1 – name: a2 – name: a3 – name: a4 – testB: – state : on – name: b1 – testC: – name: c1 How can i iterate over the above YAML file using C++(yaml-cpp) so that i can verify if […]

Categories

## sorting text file by date column

How to sort text file by date properly in sample below? The problem is that sort -k1,1 does not really work and neither can i use the dot notation such as sort -k1.6,1.9 -k1.4,1.4 -k1.1,1.2 because the form does not have a fixed length. I came up with this horror awk ‘{split($1,a,”.”);print a[1],a[2],a[3],$2}’ test.txt | […]

Categories

## Mongo DB collecting properties as a an array

I am a novice in Mongo database: I have a document in a collection, let’s say with 5 properties(A,B,C,D,E). And, I have documents in the collection that contains all or some of the above properties. I want to write a query that will append the property values from all of the documents. Document 1 = […]

Categories

## Formula to copy a cell from another worksheet where the name of worksheet to be copied from varies

I have a workbook with a worksheet containing the following: Destination Worksheet The data in cells B1, C1, D1 need to be equal to the value of cells A1, A2, A3 in a worksheet in same workbook named DOD11.2 (i.e. the name of the worksheet is the same as the letters up to the character […]

Categories

## How to fetch entire record if match is found in csv file | linux |

I have a scenario where i want to fetch record from csv file if match is found sample data “ID”,”NAME”,”CITY” “001”,”A1″,”B1″ “001”,”A2″,”B2″ “001”,”A3″,”B3″ “001”,”A1″,”B1″ “001”,”A1″,”B1″ “001”,”A1″,”B1″ when i grep a keyword like “A1” then all record which as A1 should be displayed as output output : “ID”,”NAME”,”CITY” “001”,”A1″,”B1″ “001”,”A1″,”B1″ “001”,”A1″,”B1″ “001”,”A1″,”B1″ My command not working […]

Categories

## Trying to INSERT data into MySQL table in one query, yet changing one specific column

I am trying to INSERT some data into my table using an SQL statement. A user completes a survey that has 10 questions, then I want to INSERT those 10 answers into the db using one SQL statement. So essentially the only 2 fields that will change will be the questionID and the answer column? […]

Categories

## SOLVED HiveQL – Grouping Count

I’m a newbie here and still facing a lot of problems in HiveQL, need to consult with you all. I have a table named Vote Table, and I’d like to count the “yes” vote for A,B,C,D (sorry I wasn’t able to post the image, so I sent it as a link instead). Vote_table But here […]

Categories

## Cross-Merge Many Videos

I have one folder with 30 videos, and another with 4. I want to merge the 30 first video as an intro to the 4, in order to create 120 different videos. In other words, imagine letters are intro videos and numbers the base video. Folder 1: A, B, C … Folder 2: 1, 2, […]