Categories
Mastering Development

Generate Multiple Matches of partial match

I created an array function, and my aim is to look through the elements of column H and compare them with elements of column D. If H partially matches D (i.e. H&"*" to D), i want the elements in column E reported for all partial matches. I use the below code, and it works fine, […]

Categories
Mastering Development

ValueError: time data ‘1’ does not match format ‘%m/%d/%y’

i am tiring to get todays date then save it in a file then read it an compare it with every day the file is opened but it is giving me this error ValueError: time data ‘1’ does not match format ‘%m/%d/%y’ and i have no idea what to do if(cc!=0): obj=open("certificance.txt","a+") obj.write(str (date.today().strftime(‘%m/%d/%y’))) obj.close() […]

Inserting Array Formula with VBA

I am trying to insert an array formula using VBA but I keep getting the error "Unable to set the FormulaArray property of the Range class" Sub Insert() Range("J2").Select Selection.FormulaArray = "=IFERROR(INDEX(‘Z:\Customer Operations\2021\Tools\[OrderLinesList.xlsx]Sales’!$C:$C, SMALL(IF(A2=’Z:\Customer Operations\2021\Tools\[OrderLinesList.xlsx]Sales’!$B:$B, ROW(‘Z:\Customer Operations\2021\Tools\[OrderLinesList.xlsx]Sales’!$C:$C)-MIN(ROW(‘Z:\Customer Operations\2021\Tools\[OrderLinesList.xlsx]Sales’!$C:$C))+1, ""), ROW(A1))),"")" End Sub Does anybody know where I am going wrong? Thanks in advance!

Categories
Mastering Development

How to keep data constant after merging from 2 or more csv file in R

I have a big data CSV file. I managed to merge them into one CSV file. Now when I read the file its is not consistent inflow. For example : file1 CSV: id date 21 2001 21 2002 21 2003 22 2001 22 2001 22 2002 file2 CSV: 21 2006 21 2005 21 2007 22 […]

Matrix to Table multiple headers

I need to convert the matrix in to table form. see the image for the required output. I’m not getting the output in right format which I require. The matrix has two headers like row 3 & row 4 in this example. I need your help in this matter. either VBA/Formulae or Pivot Table. I […]

Matrix to Table multiple headers

I need to convert the matrix in to table form. see the image for the required output. I’m not getting the output in right format which I require. The matrix has two headers like row 3 & row 4 in this example. I need your help in this matter. either VBA/Formulae or Pivot Table. I […]

Matrix to Table multiple headers

I need to convert the matrix in to table form. see the image for the required output. I’m not getting the output in right format which I require. The matrix has two headers like row 3 & row 4 in this example. I need your help in this matter. either VBA/Formulae or Pivot Table. I […]

Categories
Mastering Development

How can I keep track of total transaction amount received by an account each last 6 month?

This is my transaction data. It shows the transactions made from the accounts in from column to the accounts in to column with the date and the amount information data id from to date amount <int> <fctr> <fctr> <date> <dbl> 19521 6644 6934 2005-01-01 700.0 19524 6753 8456 2005-01-01 600.0 19523 9242 9333 2005-01-01 1000.0 […]

How to get full path of user’s file upload?

We have an issue tracking system on our intranet where we need to add effected files to the issue, including the path of the file. We have been using an asp.net FileUpload control and using FileUpload1.PostedFile.FileName to get the path of the file that the user selects and uploads. The files are usually not on […]

Categories
Mastering Development

Shiny: Best use case to download and process data and then plot it using plotly

I have some Shiny App which collects some CSVs from a URL – cleans it etc. and then puts it into a data frame. The below code which does that is: urlValencianStatistics <- "https://dadesobertes.gva.es/va/dataset/covid-19-total-acumulat-casos-confirmats-pcr-altes-persones-mortes-i-hospitalitzades-i-en-uci-2020" urlValencianStatistics <- readLines(urlValencianStatistics) urlValencianStatistics <- urlValencianStatistics[str_detect(urlValencianStatistics, "https://dadesobertes.gva.es/dataset/686fc564-7f2a-4f22-ab4e-0fa104453d47/resource/", negate = FALSE)] urlValencianStatistics <- str_replace_all(urlValencianStatistics, " <a href=\"", "") urlValencianStatistics <- str_replace_all(urlValencianStatistics, "\" […]