Tag: data

Microsoft Excel – combine data with a different header

I have a majority of several worksheets even having header
but one (1) spreadsheet has a different header

I have this code that will combine them all

Under handset ()

Dim xWs As Worksheet
In case of error, next recovery

Set xWs = ActiveWorkbook.Worksheets.Add (Sheets (1))
xWs.name = "Combined"
Sheets (2) .Range ("A1"). Destination EntireRow.Copy: = xWs.Range ("A1")
For i = 2 TB Worksheets.Count
Worksheets (i). Range ("A1"). CurrentRegion.Offset (1, 0) .Copy _
Destination: = xWs.Cells (xWs.UsedRange.Cells (xWs.UsedRange.Count) .Row + 1, 1)

following

Dim s As Worksheet, t As String
Dim j as long, k as long
K = Sheets.Account

For j = K To 1 Step -1
t = Leaves (j) .name
If t <> "Combined" then
Application.DisplayAlerts = False
Leaves (j) .Delete
Application.DisplayAlerts = True
End if
Next j

End Sub

it works well but I want my 1 sheet to be inserted in column D until its last column

sheet3 does not contain the first 3 columns of the other sheet
Example

sheet1, sheet2 and sheet 4 contain these columns

Branch | Population | Store | name | age | ...

while leaf3 contains

name | age | ...

the others are the same as the first 3 columns are not.
I do not do what I am going to add to the code to insert in the designated column.

oh they contain different data values

Thank you!

Data Structures – Lists and Tables in Python

If in the lists, the data is stored in random memory locations with a pointer to the next location, how can we read lists easily with an index?
In Array, this is a continuous block of memory, which makes indexing possible. I've read that reading a chart is more effective than reading a list.
I'm confused.
I am particularly concerned about Python.

SQL Server 2008 R2 – Missing data in sqlserver

You have not aliased the OPENQUERY result set as "PS" in the supplied query. Without the "PS" alias, SQL Server does not know what it is. PS.TXN_ID therefore has no meaning.

Try that:

SELECT TXN_ID
FROM OPENQUERY (PEX, & # 39; SELECT TXN_ID FROM PEX.PEX_SALE_TRAN_CUBE & # 39;) ps
WHERE NOT EXISTS (select TXN_ID in PA_TRANSACTIONS PT WHERE PT.TXN_ID = PS.TXN_ID)

Otherwise, try using the EXCEPT operator:

SELECT TXN_ID
FROM OPENQUERY (PEX, & # 39; SELECT TXN_ID FROM PEX.PEX_SALE_TRAN_CUBE & # 39;)
EXCEPT
SELECT TXN_ID FROM PA_TRANSACTIONS

EXCEPT Operator

raw – How to obtain focal length data from proprietary file formats (CR2, ARW, etc.)?

I am looking for a way to read the equivalent EXIF ​​data (focal length, camera brand, etc.) from RAW file formats, preferably in javascript. I've been able to read EXIF ​​from JPG, but there do not seem to be any libraries for RAW formats.

I have consulted this resource and I know the files "tags" (http://lclevy.free.fr/cr2/), but I do not know how to read them with javascript.

Any help is greatly appreciated!

How to create a while loop in a student program and interrupt it when you stop typing data

It's a program that calculates the average of a group and that can break the cycle whenever it wants to](Https://i.stack.imgur.com/L0typ.png)

customization – WooCommerce custom data from JS code

I work at an online shoe store and he needs the option for customizable shoes with live preview. I have written the application for this in JS, you can select up to 7 colors for 8 different parts of the shoe.

The application of costume shoes is on a separate page and it has nothing in common with the rest of the WordPress website. My problem is that at the end of the customization, I do not know how to add the article to the cart with all the details.

The "variable product" is not an option because I have nearly 500,000 different variants. I think the best option would be to use the "costum item data" of the WooCommerce options, but I do not know how to do this from JS nor how to get the information from my JS code and use it in WP .

Any idea is very appreciated.

sql – Filter to get the biggest data by date

I have the following table:

    id n1 n2 date
1181 1 26 2019-02-03
1183 1 20.9 2019-02-03
1185 1 20 2019-02-04
1187 1 21.7 2019-02-04
1189 1 22 2019-02-04
1191 1 22.5 2019-02-04
1193 1 20 2019-02-04
1195 1 22.9 2019-02-04
1197 1 22.8 2019-02-04
1199 1 22.8 2019-02-04
1201 1 22.6 2019-02-04
1203 1 22.5 2019-02-05
1205 1 22.4 2019-02-05
1207 1 22.6 2019-02-05
1209 1 21 2019-02-05
1211 1 19.8 2019-02-05
1213 1 21.8 2019-02-05
1215 1 22.3 2019-02-05
1217 1 21 2019-02-05
1219 1 22.8 2019-02-05
1221 1 23.1 2019-02-05
1223 1 21.3 2019-02-05
1225 1 21.9 2019-02-05
1227 1 21.7 2019-02-05
1229 1 22.9 2019-02-05
1231 1 22.8 2019-02-05
1233 1 22.7 2019-02-05

I have to filter the array so that at each date only the upper value of n2 is delivered, that is, in this example, it would be:

                1181 1 26 2019-02-03
1195 1 22.9 2019-02-04
1221 1 23.1 2019-02-05

I have tried with:

SELECT n2, date
DE dbo.table
O id = 1 & # 39;
GROUP BY n2, date
ORDER BY date ASC, n2 DESC

But with that, I've only managed to order it, without success in the filter I want, could you help me please?

Thank you

Get data from another Google sheet that is not in the same order

I have a very basic knowledge of the deeper functions of Google's sheets and the resolution of this problem has been a bit painful until now.

I have a spreadsheet A
– column A contains the ID
– Column I which contains the information I need to receive

I have spreadsheet B
– in column X, I must obtain the exact data contained in spreadsheet A, column I

The problem is that these two worksheets do not have the same order of identifiers, that's why I first need to find the correct identifier, THEN to duplicate the data in my spreadsheet B, column X.
Column A of the two sheets contains identifiers, just matched to each other.

Thank you for your help, I hope this explanation is quite understandable.

Google fact sheet – Validation of data, restriction

I have supported a project on Kickstarter and the creator of the project has started the delivery process. However, orders take a lot of time and many people are impatient and upset. And that does not help when the creator of the project refuses to provide useful information about the shipping status.

So, to help people, I decided to create a spreadsheet with the order information of the sponsors and to know if their order was shipped / filled or not.

However, there are people who like to troll and spam the spreadsheet with useless information. The fact that Google Sheet does not have granular permissions restrictions does not help.

I need to prevent duplicate data entry (spam). Until now, I can set data validation with the help of a custom formula, as follows:

= countif (A $ 1: A1, A1) = 1

However, this only works if users manually enter duplicate data. If they fill the cells or if they copy and paste data into multiple cells, the data validation will not work.

I must also prevent them from adding new sheets or deleting an entire sheet.

design – Designing a Big Data Web Application

How do you design a website that allows users to query a large amount of user data, specifically:

  • there are about 100 million users with about 100 TB of data, the data is stored in HDFS (not a database)
  • the number of queries (simultaneous) is not important, but each request must be as fast as possible
  • support simple queries such as: get user information by username, get
    accumulated data such as monthly connections and monthly online time

I am more interested in the process of thinking about how to approach this requirement. For example:

  • to 100 users, what is the design?
  • on a million users, what needs to change?
  • to 100,000,000 users, what is the design now?

I've traveled the world and seen a lot of people talk about caching, load balancing, … Of course, these techniques are useful and can be used, but how do you know that this can help manage N users? And if, for example, the addition of caching allows to manage 10 users while the system needs only 3 users of the server. Nobody seems to explain this point.