Fantasy names database

I am building a demo dataset for my webapp. I would like thousands of "real looking" names. They should not be names of famous people or fiction heroes or names that will evoke associations. They...

Problem in fitting the excel cell size to the size of the content when using apache poi

I am beginner to Apache POI api. I am trying to create excel sheet using arraylist. My java code is as follows. HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("new...

Howto remove Listeners on SWING JComponents

is there an easy way to remove all Listeners from a JComponent? JComponent widget = getComponentOverScaryMethod(); EventListener[] listners = widget.getListeners(EventListener.class); for...

Why no many-to-many relationships?

I am learning about databases and SQL for the first time. In the text I'm reading (Oracle 11g: SQL by Joan Casteel), it says that "many-to-many relationships can't exist in a relational...

JPA createQuery and flush/clear

The following code works, however if I remove the flush() and clear() calls, then the second call to showTable() does not show the updated name "joan", but "john". What is the proper way to...

path.node().getTotalLength() hangs the browser

I'm trying to generate a line chart but I'm getting errors trying to get the length of an svg path with the function getTotalLength(). This is strange to me because Firefox 19.0.2 runs fine but...

Getting imported json data into a data frame

I have a file containing over 1500 json objects that I want to work with in R. I've been able to import the data as a list, but am having trouble coercing it into a useful structure. I want to...

Java 8: Formatting lambda with newlines and indentation

What I would like to achieve with lambda indentation is the following: Multi-line statement: String[] ppl = new String[] { "Karen (F)", "Kevin (M)", "Lee (M)", "Joan (F)", "Des (M)", "Rick (M)"...

Liquibase Error: Found multiple catalogs matching

I have a simple change log file for testing purposes that applies 1 changeSet which drops a table and creates it. We have 20 DEV / QA databases all on the same version of DB2, OS, etc. This...

pandas merge dataframe with NaN (or "unknown") for missing values

I have 2 dataframes, one of which has supplemental information for some (but not all) of the rows in the other. names =...

SQL Server Equivalent of Oracle 'CONNECT BY PRIOR', and 'ORDER SIBLINGS BY'

I've got this Oracle code structure I'm trying to convert to SQL Server 2008 (Note:* I have used generic names, enclosed column names and table names within square brackets '[]', and done some...

Scrape some text from another website without any url or special charecters

I'm trying to learn some using of code, and i'm trying to scrape information or some text from another site to my (for personal usage only). well, for example i want to take information from this...

Datatable columns width

I've set up a datatable with several rows and columns and would like to know how can I make the "Tel. 1, Tel. 2 and Fecha" columns a little wider so that the text shows in a single line. I've...

Regex strong password the special characters

I am currently making some tests with regex. I had an exercise which requested to check for a strong password, which means it should have: at least one number,one lowercase letter, one uppercase...

Pascal Runtime Error 106 on Homework

First time posting here so I will try to do it right. I'm working on my first program which prints the percentages for a class of students given an id,last & first name, and an assignment score...

Regex string with 3 or more vowels

I'm trying to make a regular expression that matches a String with 3 or more vowels. I've tried this one: [aeiou]{3,} But it only works when the vowels are in a sequence. Any tips ? For...

Check Error Count Angular Reactive Forms

I want to conditionally apply a css class if the error count in a form is greater than 1. How do I do this in angular4? Component: import { Component } from "@angular/core"; import { FormGroup,...

R highcharter - grouped categories - missing label for group with one value only

R Code: setwd(dirname(rstudioapi::getActiveDocumentContext()$path)) options(stringsAsFactors = FALSE) rm(list = ls()) if (!require("pacman"))...

Error Installing python-ldap package

I'm trying to install the python-ldap package with PyCharm and it is not working out, i get the following error: Error Message: Collecting python-ldap Using cached...

Convert 2D array to object using map or reduce in javascript

Is it possible to convert [[35, "Bill"], [20, "Nancy"], [27, "Joan"]] to {"Bill": 35, "Nancy": 20, "Joan": 27} using the .map() or .reduce() methods? I can convert the array using: const arr =...

Scrape Span Text from Google

I'm new to scraping and I'm trying to scrape text from google search results but I keep getting empty results. I have a list of names and I need to get their google search Text results from <span...

Xpath - remove duplicate and sorted distinct list

I am using a Excel FILTERXML function to return a distinct list. The formula is : =FILTERXML(StudentList,"//b[not(preceding::*=.)]") I create a define name called "StudentList" for the xml The...

Convert JSON to SQL row

I have this below JSON and I would like to load them to my MSSQL table [{"Item_name": ["Lizinka", "L4690.S53", "Alder Pebble Grain Leather Boot w/ Walking Sole", "Becketts Oxford", "Phillip II...

Flask Application was not able to create a URL adapter for request

I have this code which used to work: import unittest from flask import url_for from dm.web import create_app, db class TestApi(unittest.TestCase): def setUp(self): """Create and...

How to map through all children with Ant Design Tree Node

I have a an array which looks similar to this: const hierarchy = [ { hierarchyId: 1, hierarchyName: 'John' children: [ { hierarchyId: 2, hierarchyName: 'Mary', ...

Python JSON TypeError: list indices must be integers or slices, not str

I am currently trying to parse some data from a get request response and I keep getting this error: "TypeError: list indices must be integers or slices, not str" it would be great, if anybody...

mat-list to display multiple items

I have a typescript file containing constant data as below: export const HELPERS: Helper[] = [ { id: '0', name: 'Joan', image: '/assets/images/img.png', designation:...

How to convert pdf into dataframe pandas python and extract values?

I download the pdf file online and want to put it into pandas dataframe. The next step is to extract the CAS and REACH number in dataframe. Could anyone help me with that? Here is the pdf link...

Pdfplumber cannot recognise table python

I use Pdfplumber to extract the table on page 2, section 3 (normally). But it only works on some pdf, others do not work. For failed pdf files, it seems like Pdfplumber read the button table...

How can I iterate over two dataframes to compare data and do processing?

I have two different dataframes: A, B. The column Event has similar data that I'm using to compare the two dataframes. I want to give Dataframe A a new column, dfA.newContext#. In order to do...