How can I merge multiple text files into one data.frame?

Suppose I have 9 .txt files in the same directory.
price1.txt price2.txt price3.txt is a table of price from different location, row and col name is longitude and altitude correspondingly.
year4,5,6.txt and dis7,8,9.txt is a table of year and discount from the same location as in text1.

I want to create a new data frame where each column is a list of a price, year, discount from text 1-9 with the corresponding longitude and attitude.

read more

How can I merge multiple text files into one data.frame?

Suppose I have 9 .txt files in the same directory.
price1.txt price2.txt price3.txt is a table of price from different location, row and col name is longitude and altitude correspondingly.
year4,5,6.txt and dis7,8,9.txt is a table of year and discount from the same location as in text1.

I want to create a new data frame where each column is a list of a price, year, discount from text 1-9 with the corresponding longitude and attitude.

read more

Need help converting a number and date in excel 2013. getting the number but 1900 for my date

I’m trying to convert a number and date together in excel 2013 as one number.

Example: Cell A1 contains a number 123456 and B1 contains a date 02/07/1976. I need to combine both so A1 reads 12345602071976. (without the dashes in the date) Instead, I’m getting 1234561900. I believe I need to insert blank columns and separate out the date and then create a formula to combine everything but I’m not sure how to do that. I’ve searched online and utube but nothing that combines both.

read more

Need help converting a number and date in excel 2013. getting the number but 1900 for my date

I’m trying to convert a number and date together in excel 2013 as one number.

Example: Cell A1 contains a number 123456 and B1 contains a date 02/07/1976. I need to combine both so A1 reads 12345602071976. (without the dashes in the date) Instead, I’m getting 1234561900. I believe I need to insert blank columns and separate out the date and then create a formula to combine everything but I’m not sure how to do that. I’ve searched online and utube but nothing that combines both.

read more

Failed to load ApplicationContext in JUnit when add Hibernate Validator

I migrate from JDBC to Hibernate in a Spring project and I’ve got an issue with Hibernate Validator.
Before adding Hibernate Validator dependency in pom.xml my JUnit tests work fine. But after I add to pom.xml:

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-validator</artifactId>
    <version>5.1.0.Final</version>
</dependency>

I get the following error for all of my tests:

java.lang.IllegalStateException: Failed to load ApplicationContext
...
Caused by org.springframework.beans.factory.BeanCreationException: Error creating bean with name &apos;sessionFactory&apos; defined in class path resource [test-hibernate-context.xml]: Invocation of init method failed; nested exception is java.lang.NoSuchMethodError: org.hibernate.internal.CoreMessageLogger.debugf(Ljava/lang/String;II)V

read more