Categories
Mastering Development

Remove duplicated elements of a column list and make comparisons

I have a dataframe where all columns are list of values (could be tuple if it facilitates the operation). The index “Name” is not a list, they are unique values in this data. Most of the lists have duplicated values: Name Department Business Unit Person Number Line Manager Name Line Manager Work Email Username Job […]

Categories
Mastering Development

SELECT and JOIN to return only one row for each employee

I have a user table that stores the employeeId, lastName, firstName, department, hire date and mostRecentLogin. I have another table that stores the employeeId, emailAddress. The emailAddress table can have multiple rows for an employee if they have multiple email addresses. I’m trying to return results that only show one row for each employee. I […]

Categories
Mastering Development

F#: How to examine content in a n-tuple and return true or false?

Consider this F# code: let isSalary employee = let (fName,lName,Occupation,Department,SalaryType, HoursPerWeek, AnnualSalary, HourlyWage ) = employee SalaryType = “Salary” if(employee.SalaryType = SalaryType) then true else false Im getting errors in here, any fixes to it?

Categories
Development

edit uploaded form using jsp

I have one index.jsp page. In this page, user will fill some fields like zid, firstname, lastname and so on. While filling fields user selects file(s) to upload into MySQL database then click on “Submit” then file will be stored with details. Stored record are shown into filelist.jsp page. I have created one folder as […]

Categories
Development

getting error while checking User Already Exists in Mysql database using java

I have tried some code to check that user is already exist in database or not while doing registration. But I am getting error like this. Please suggest me where I am getting wrong. Thanks in advance. I am using netbeans 8.2, apache tomcat, MySQL database(XAMPP) Here is my code String zid = request.getParameter(“zid”); String […]

Categories
Development

Conversion failed when converting the nvarchar value ‘….’ to data type int

I’m trying to create an Update Statement for my Table in JavaFx and I’m receiving following Error: Conversion failed when converting the nvarchar value ‘Ana’ to data type int. I created the tables in SQL Server.In my database only age is from type int, everything else is String. Here is my Code: public void handleUpdateAction(ActionEvent […]

Categories
Development

SQL query to find the visitor together with the date time

My visitor log table has id, visitor, department,vtime fields. id | visitor | Visittime | Department_id ————————————————————– 1 1 2019-05-07 13:53:50 1 2 2 2019-05-07 13:56:54 1 3 1 2019-05-07 14:54:10 3 4 2 2019-05-08 13:54:49 1 5 1 2019-05-08 13:58:15 1 6 2 2019-05-08 18:54:30 2 7 1 2019-05-08 18:54:37 2 And I have […]

Categories
Development

I am trying to hide data on the basis of certain condition

I am trying to hide the data for a single column if the column contain value that is in exceptionList then it should escape and move to next but somehow i am not able to hide that and throws error if(x in exceptionList): ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), […]

Categories
Development

unable to lookup pickle binary file . dat

I am trying to lookup on pickle dictionary but I get, search not found mainly because I don’t see my file on the hard drive, “employee.dat” even though I saved it using pickle. My problem here is that I also can’t modify and save the information for some reason. I tried to use different ways […]

Categories
Development

unable to lookup pickle binary file . dat

I am trying to lookup on pickle dictionary but I get, search not found mainly because I don’t see my file on the hard drive, “employee.dat” even though I saved it using pickle. My problem here is that I also can’t modify and save the information for some reason. I tried to use different ways […]